Excel cannot access analsys32.xll file

[Anali]

I'm trying to add-in the Analysis TookPak and I keep getting the error
message that it cannot run this add-in and the feature is not avaiable. It
asks me if I would like to install it now, I click Yes, but then I get a
message saying it cannot access the file 'analysis32.xll'.
What do I do?

 

[Gord Dibben]

Anali

The default location on a regular installation is in the 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.

Assuming you have the installation CD, of course.


Gord Dibben Excel MVP