I have run into the same custom function. However the function works if I
open the spreadsheet in Excel 2003, however in 2007 I get the #NAME? formula
error.
Looking through the VBA code there are no custom functions, yet the same
file works fine in 03.

help?

Tim




"Kurt" wrote:

Unfortunately, the function doesn't appear in any of the worksheets under the
VBA editor. In order to remedy the problem, I started Excel, forced manual
calculation, and then opened the workbooks.

This allows me to work with the data, just not with the provided worksheets.

Thank you, all, for your input.



"NoodNutt" wrote:

Sound like whoever designed it created his/her own workbook function.

Open the VB Code window and check out the sheet in question and any modules
that may be there.

Good luck

HTH
Mark.