Problem with compability.

H

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
 
R

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.
 
D

Dave Peterson

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Working outlook via vba code with xlsx - error 0
Excel does not accept text format! 0
Security Alert Macros have been disabled - Excel 2007 4
Excel Version 2
Disable the cancel option while saving the excel sheet-Excel 2007 0
Find value with the help of macro. 5
Problem with multilingual VBA Programming 3
Range row Address. 4

Top