Problem with compability.

[Heera]

Hi,

New users are getting excel 2007 and the old users still have 2003 version
of excel.

I used one formula "NETWORKDAYS" but this formula doent working in excel
2003 and it is giving an error. Does any one knows solution.

Regards
Heera

 

[Rick Rothstein]

You have to activate the Analysis ToolPak add-in for XL 2003. Go to Excel's
menu bar and click Tools/Add-Ins and then place a check mark next to the
Analysis ToolPak item and then click the OK button. The reason this is not
required in XL2007 is because Microsoft built the functions from the
Analysis ToolPak into that version of Excel.

 

[Dave Peterson]

=networkdays() requires that the analysis toolpak be installed (tools|addins) in
versions earlier than xl2007.