Loading the Analysis ToolPak
Load or Unload? You use both terms.
Assuming "unload" is a typo...........
The ATP is available under ToolsAdd-ins?
You have it checked?
Try unchecking, close dialog then ToolsAdd-ins and re-check it.
If not available have a look in the default install folder.
C:\Program Files\Microsoft Office\Office11\Library\Analysis
There will be 4 files in the Analysis folder.
ANALYS32.XLL
FUNCRES.XLA
ATPVBAEN.XLA
PROCDB.XLA
If not found there, suggest you try the control panel add/removechange and
go in and remove the ATP installation then re-install just the ATP
Assuming you have the installation CD, of course.
Gord Dibben MS Excel MVP
On Sat, 14 Nov 2009 14:12:01 -0800, marcus
wrote:
I am familiar with the process and instructions on how to unload the analysis
toolpak. However, when I follow the instructions, I get the following error
message: Microsoft Office Excell cant run this add-in. This feature is not
currently installed. Would you like to install it now?
Upon selecting yes, I get the following error message:
Microsoft Office Excel cannot access the file 'analys32.xll' There are
several possible reasons. -The file name or path does not exist, -The file is
being used by another program, -The workbook you are trying to save has the
same as a currently open book.
Please help me with this problem. Thanks
|