Analysis toolpak

[Guest]

I am trying to add in the analysis toolpak. I go to >tools >addins and check
"analysis toolpak." When I click ok, I keep getting an error message telling
me the file does not exist. It does not offer me any chance to browse for
the file. How do I ad in the toolpak?

 

[Gord Dibben]

Analysis Toolpak is an add-in that should have installed with Office and
Excel.

Since the Analysis Toolpak Add-in appears in your Tools>Add-ins list, it
sounds like it was installed.

Do a file search for these files........make sure Windows is set to "show
hidden files".

Look for them in your Office10 Library first.

C:\Program Files\Microsoft Office\Office10\Library\Analysis

Four files in here.......

ANALYS32.XLL
ATPVBAEN.XLA
FUNCRES.XLA
PROCDB.XLA

When you do the install do you select "typical" or "custom"? The typical
install will include the toolpak add-in.

If you cannot find anywhere on Hard Drive suggest you plop in the Office CD
and do a partial install. Perhaps uninstall the add-in components then
re-install.


Gord Dibben Excel MVP