can't access the add-ins to get to data analysis

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am supposed to use data analysis in excel for a class assignment, but I keep getting a message that the tool pack needs to be installed. Is a disc the only way to download this information. I was told that it should have already been in the program.
 
Hi
try the following
- goto 'Tools - Add-in manager'
- check the Analysis Toolpak Add-in

you may have to restart Excel
 
Lex

If not available in Tools>Add-ins, perhaps the installation was a "custom"
install and the original installer did not check the Analysis Toolpak.

Do a file search for Funcres.xla or Analys32.xll

Normal path is C:\Program Files\Microsoft Office\Office10\Library\Analysis

If can't be found, go to Control Panel>Add/remove and click on MS Office and
"Change". Have CD ready.

Gord Dibben Excel MVP
 
Back
Top