Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with compability.
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with compability.
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. -- Rick (MVP - Excel) "Heera" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with compability.
=networkdays() requires that the analysis toolpak be installed (tools|addins) in
versions earlier than xl2007. Heera wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find cell that has compability issues | Excel Discussion (Misc queries) | |||
Problem when multipple users access shared xl-file at the same time, macrocode for solve this problem? | Excel Programming | |||
Version compability of classes? | Excel Programming | |||
Excel 2000-2002 compability | Excel Programming |