analysis toolpak

[Guest]

How do get this add in! tried using tools function and re-installing cd, but
not happening!

 

[Ken Wright]

All you *should* have to do is hit Tools / Addins / Check the Analysis
Toolpak addin and then you may or may not be prompted for the disk. This
then gives you extra functions you can use and some more options under
Tools.

 

[Gord Dibben]

Ashanti

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

Do you see it when you go to Tools>Add-ins? If not, 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 through Control Panel>Add/Remove>Change. Perhaps
uninstall the add-in components then re-install.


Gord Dibben Excel MVP