WORKDAY formulas reverting to #N/A ?

[Me!]

Hi,

I have a file in which I use the WORKDAY fnction extensively in many
formulas.

However, recently I have opened the file and all the formulas are showing
#N/A in the formula bar, but the cell still shows the date (which was the
reult of the formula).

I don't know how or why this is happening. Any advise could be welcome.

many thanks,

jason
---

 

[Bernd P]

Hello Jason,

Press ALT + T, then ALT + I and tick the Analysis Toolpak box. Will
work then.

Regards,
Bernd

 

[David K. Dickson]

I work for a company which uses Excel 2007, but our client uses Excel 2003, so we have to run 2007 in Compatibility Mode for the files that we both share

I can enter formulas using the WORKDAY() funtion and they display the correct results. Then I save the file (in Compatibility Mode). The next day, I open it again and some of the cells containing the WORKDAY() function now display the correct value in the cell, but in the formula bar they show =#N/A. Other cells containing the WORKDAY() function now display =#N/A in the cell and in the formula bar as well.

 

[Bob I]

Perhaps you may point your client to this link

How to install the Microsoft Office Compatibility Pack so that you can
use earlier versions of Excel, PowerPoint, and Word to open and to save
files from 2007 Office programs
http://support.microsoft.com/kb/923505