View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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