PICalcDat function results in #NAME?. How do I fix this?

[Kurt]

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!

 

[Bernard Liengme]

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

 

[David]

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

David

 

[NoodNutt]

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.

 

[Kurt]

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.

 

[TDS]

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