Funcres.xla

  • Thread starter Thread starter Craig
  • Start date Start date
C

Craig

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?


Thanks.
 
Craig said:
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 *
 
Funcres.xla is the Analysis ToolPak functions for use in Excel worksheets.
It is loaded when you check the toolpak option under Tools|AddIns. It is
password protected, so you cannot just mess about with it.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Thanks for the answers!
-----Original Message-----


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 *



.
 
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.
 
The Analysis ToolPak add-in should be included with a regular install of Excel
or Office.

Check in Tools>Add-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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Back
Top