User Defined function error?

Question

Hello,

We are getting the following message when opening on of our spread sheets.  "The following user-defined functions, created in an older version of Excel, have the same name as built-in Excel functions.  When these function names are used in a formula, the new built-in function will be used, which may cause different results.  Then it list a function named "Function" and one named "Sort".  I searched through the entire set of VBA project modules and there is no such functions defined in our file.

Answer 1

I think I've found the problem where Excel thinks that a UDF Sort is called (see text in bold):

<v:textbox style='mso-direction-alt:auto' o:singleclick="f">

  <div style='text-align:center'><font face="Arial" size="200" color="auto">Sort Standards</font></div>

  </v:textbox>

  <x:ClientData ObjectType="Button">

    <x:Anchor>

      1, 7, 4, 24, 2, 34, 4, 45</x:Anchor>

      <x:PrintObject>False</x:PrintObject>

        <x:AutoFill>False</x:AutoFill>

<x:FmlaMacro>[0]!_xludf.Sort</x:FmlaMacro>

            <x:TextHAlign>Center</x:TextHAlign>

              <x:TextVAlign>Center</x:TextVAlign>

              </x:ClientData>

Please follow this steps:

Make a backup copy of the file

Open Excel

File \ Open \ Browse \ Select the file \ Press the SHIFT key and hold it down \ Click Open

Wait till the file is opened \ Release the SHIFT key

Press Alt-F11 to open the VBA Editor

Go into module PI_Stds and search for Sort (it's the second sub from the bottom)

Rename Sub Sort() to Sub MySort()

Close the VBA Editor

Go into sheet "Standard Sheet Index"

Right-click the "Sort Standards" button (within cell B5) and choose "Assign macro"

Select "MySort" and click Ok

Select cell A1

Save the file

Close and Reopen Excel

Does this fix the issue?

Andreas.

Answer 2

I searched through the entire set of VBA project modules and there is no such functions defined in our file.

It might be possible that it is not inside the VBA project.

Can I have a copy of the file? I like to investigate that issue.

Andreas.

Answer 3

Ciao Andreas

Just in case where one of the previous ideas did help & we get no news… May I know what you have in mind?

Answer 4

OK we do have Adobe Acrobat Pro several computer.  That has an excel add-on, but that is on for all our excel files and the message for the "Sort" and "Function" custom user-defined function only appears in certain workbooks.

Answer 5

Thanks for the reply.  I check my references and below is a list of what I have on.  The all look to be standard references.

I have determined that since I can find no actual use of these two user-defined functions in my workbook or the definition in my scripts that the issue should not effect any of my calculations or outputs.  So I toggled on the button on the dialog that shows "Do not show this dialog again". Hope that does not come back to bit me.

PS the help button on that dialog does nothing.