Hi ThePizza!
If Analysis ToolPak is not installed or selected any cells containing
Analysis ToolPak functions and all dependent cells will return the
dreaded #NAME! If that happens read on. In any case, you should read
on if you are building an application that others might use especially
if used on different computers.
***Excel 2002 and 2003***
Use Tools > Add-Ins
Check the Analysis ToolPak entry. If you get no messages, press OK.
Depending upon whether its been used before and upon load on first use
options used during installation, you may get messages requiring you
to insert the setup discs.
Once selected, Analysis ToolPak will be loaded every time Excel boots
up until it is de-selected as an Add-In. There is a small penalty in
terms of opening speed that varies from system to system depending
upon specification.
***Excel 2000 and before***
Use Tools > Add-Ins [For old specification computers it might take a
few seconds before anything happens!]
If there is an Analysis ToolPak entry in the Options listed just put a
check against it and press OK. If there is not an Analysis ToolPak
entry you will need to close Excel and re-run the Setup discs. You
will find that Analysis Toolpak is listed as one of the options for
Excel's installation.
Once that is done you may open Excel and you'll find that it is now
listed as an Add-In when you use Tools > Add-Ins.
Once selected, Analysis ToolPak will be loaded every time Excel boots
up until it is de-selected as an Add-In. There is a small penalty in
terms of opening speed that varies from system to system depending
upon specification.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
