how do i set up analysis toolpack?

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

Guest

I did the whole go to tools, clicked on add-ins and checked off analysis
toolpack; but for some reason it will not install. Am I to have a disc for
this? In what way can I install this portion of excel? Need it urgently for
school...Thanks!
 
It's on the installation disc, so you will likely need to put that in before
you do as you just said.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------­------------------------------­----------------
 
You do not "install" the ATP from Tools>Add-ins.

You "load" it from Tools>Add-ins.

How do you know it is not loaded? Do you get some sort of error message?

Do you not see Tools>Data Analysis?

If the ATP is listed in Tools>Add-ins and you get no error message when you
checkmark it, it is installed.

Perhaps you have Tools>Customize>Options "always show full menus" unchecked?

You could also try re-setting the Worksheet Menu Bar.

Tools>Customize>Toolbars>Worksheet Menu Bar>Reset.

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 definitely not installed, have your CD ready and go to Start>Settings>Control
Panel>Add/remove programs and select Office to make changes.


Gord Dibben MS Excel MVP
 
Back
Top