Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Option - Analysis Tools
I remember I have turn on the option - analysis tools once for using workday
function on other workbook, but this option is not selected on another workbook. Do I need to turn on this option - analysis tools on each workbook individually in order to use workday function on every workbook? I think I only need to turn on this option once, that is all. Does anyone have any suggestions why I need to turn on the option more than one time? Does it cause by recently upgrading from Office 2000 to Office 2003? Thank in advance for any suggestions Eric |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Option - Analysis Tools
Eric,
It isn't really an "option" to turn on but rather an Add-In to be loaded. To use the Analysis Tool Pack function such as WORKDAY, you must load the ATP. From the Tools menu, choose Add Ins and check "Analysis Tool Pack". When that add in is loaded, you have access to the function. If the ATP is not loaded, you'll get #NAME errors. An Add In operates at the Application level. That is, when it is loaded, all open workbooks can use the function in the Add In; it need not be enabled or loaded for each workbook. Upgrading from 2000 to 2003 has no difference on the ATP. The only version difference regarding the ATP is with Excel 2007. In 2007, the functions that were previously in the ATP are now native Excel function so the ATP isn't required to use them. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting www.cpearson.com (email on the web site) "Eric" wrote in message ... I remember I have turn on the option - analysis tools once for using workday function on other workbook, but this option is not selected on another workbook. Do I need to turn on this option - analysis tools on each workbook individually in order to use workday function on every workbook? I think I only need to turn on this option once, that is all. Does anyone have any suggestions why I need to turn on the option more than one time? Does it cause by recently upgrading from Office 2000 to Office 2003? Thank in advance for any suggestions Eric |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data analysis tools | Excel Worksheet Functions | |||
Any tools to apply ARIMA analysis within Excel? | Excel Discussion (Misc queries) | |||
I added analysis toolpack, but does not appear in tools menu | Excel Discussion (Misc queries) | |||
How do I get Analysis Tools in English | Excel Worksheet Functions | |||
Analysis ToolPak installed but no Data Analysis option | Excel Discussion (Misc queries) |