how can i load the analysis toolpak without the cd

[Guest]

the subject is pretty self explanatory. i need to load the analysis toolpak
in excel 2000 without using the CD.

 

[Gord Dibben]

Adam

The default location on a regular installation is in the folder

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

There will be 4 files in the Analysis folder.

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

You need all 4 files.

To download the 97 versions of these files go here.....

http://www.stat.jmu.edu/trep/Marchat/sp2001/Library.htm

I believe there is no difference between 97 and 2000 versions but use at your
own risk.


Gord Dibben MS Excel MVP