I'm working on an Excel sheet for a client. When I open it, half the document
is full of #NAME? cells, indicating an unknown function. The root of the
problem seems to be the PICalcDat function. How do I fix this issue? Is there
some add-on I can install?

I use Excel 2003.

Thank you!

Could be wrong, but this looks like it might be a user created function. I
have never seen this function.

David

"Kurt" wrote:

I'm working on an Excel sheet for a client. When I open it, half the document
is full of #NAME? cells, indicating an unknown function. The root of the
problem seems to be the PICalcDat function. How do I fix this issue? Is there
some add-on I can install?

I use Excel 2003.

Thank you!

Yes, you need to have that function either in your workbook or another opwn
workbook or addin book. I have never seen this function. Ask the person who
gaqve you the workbook.
best wishes
Bernard Liengme
Microsoft Excel MVP
people.stfx.ca/bliengme
remove caps from email address

"Kurt" wrote in message
...
I'm working on an Excel sheet for a client. When I open it, half the
document
is full of #NAME? cells, indicating an unknown function. The root of the
problem seems to be the PICalcDat function. How do I fix this issue? Is
there
some add-on I can install?

I use Excel 2003.

Thank you!

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.

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.

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.