adding "Data Analysis" to my Excel

[Guest]

I cannot see the "Data Analysis" option under the Tool Menu in Excel.
I would like to know what i am missing. what do i need to install to have
this option and be able to use its functions.
how can i get any file (.dll) that i may need

thanks

 

[Carim]

Hi Mirna,

First, you need to go to Tools Add-Ins to select whatever Add-In
you need ...

HTH
Cheers
Carim

 

[Gord Dibben]

Mina

Have you gone into Tools>Add-ins and checked the Analysis Toolpak?

Don't check the Analysis Toolpak - VBA

If you don't see the ATP in the list...........................

The default location on a regular installation is in the folder

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

There will be 4 files in the Analysis folder.

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

If not found there, suggest you try the control panel add/remove>change and go
in and remove the ATP installation then re-install.

Assuming you have the installation CD, of course.


Gord Dibben MS Excel MVP

I cannot see the "Data Analysis" option under the Tool Menu in Excel.
I would like to know what i am missing. what do i need to install to have
this option and be able to use its functions.
how can i get any file (.dll) that i may need

thanks

Gord Dibben MS Excel MVP