The Analysis ToolPak add-in should be included with a regular install of Excel
or Office.

Check in ToolsAdd-ins for it. If seen, place a checkmark in the option box.

If you don't see it listed, do a File Search in Windows for ANALYS32.DLL or
FUNCRES.XLA

If not found, you can go to Control Panel Add/Remove and click on MS Office
and "Change".

Go through the options for adding files and features. Have your CD ready.

Gord Dibben Excel MVP


On Tue, 25 May 2004 21:44:28 -0700,
wrote:

I have a different problem, Funcres.xla can't be found !
I need it for analysis toolpak to work - so they dont.
yield, regression etc. please help.
-----Original Message-----
"Craig" wrote in message
.. .
I'm using Excel 2002. When viewing the VBA editor in
an
Excel workbook, I notice an object called Funcres
(funcres.xla). When I click on it, it asks me for a
password. What exactly is this?

Hi Craig,

This is the add-in file for the Analysis Toolpak. In
the Excel interface
choose Tools/Add-ins from the menu. The Analysis Toolpak
should be close to
the top of the list. Just uncheck it if you don't want
this workbook to load
every time you start Excel. Note that it has to be
loaded in order to use
any of the worksheet functions that are included in it.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *



.