Loading the Analysis ToolPak

[marcus]

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

 

[Gord Dibben]

Load or Unload? You use both terms.

Assuming "unload" is a typo...........

The ATP is available under Tools>Add-ins?

You have it checked?

Try unchecking, close dialog then Tools>Add-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/remove>change 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

 

[Mike]

Gord,

I followed your advice and do not appear to have the ATP installed at all.
How do I install this from the CD?

Thanks

 

[Bob Phillips]

Load the CD, choose the Reinstall/Update option, make sure you select Custom
install and then pick the ATP from the addins installation list

HTH

Bob