how do i set up analysis toolpack?

[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!

 

[Ken Wright]

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
------------------------------­------------------------------­----------------

 

[Gord Dibben]

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