Loading the Analysis ToolPak
 

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

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

Loading the Analysis ToolPak
 

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

"Gord Dibben" wrote:

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

.

Loading the Analysis ToolPak
 

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

"Mike" wrote in message
...
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

"Gord Dibben" wrote:

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

.