Date calculation cell became #NAME?.

[Cam]

Hello,

I have hundreds of row with column ship date, complete date, etc...
For the column of complete date, I have this formula which calculate 15 days
from the ship date field excluding holiday.

=(WORKDAY($B162,-15,Holiday!$A$2:$A$24))

Every rows are calculated for example:
Ship Date = 2/28/08 so the calculated complete date is 2/7/08.

But, once I hide the top several rows that I don't need to show anymore, all
the calculated date became #NAME?. This also happen when I double click on
the complete date cell. What is causing this and is there a way to fix it?
Thanks

 

[Ron Coderre]

It sounds like the Analysis ToolPak add-in became disengaged.

Try this:
From the Excel Main Menu:
<tools><add-ins>
....Check: Anlaysis ToolPak
....Click [OK]

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)