Analysis Toolpak not visible in Tool menu

[Roman J]

After I add analysis toolpak in Add-ins, Excell istalls
it, but I still can't find it and access in Tools menu.
All the files required are present at Library/Add-ins
catalogue. Both Excel 2000 and XP have this problem on my
computer.

how can I fix it?
is there any way to use the functions from Analysis
Toolpak by typing them in?

 

[Katherine Coombs]

Roman,

what are you trying to achieve? The Analysis toolpak add-in doesn't create
another toolbar etc - it loads new functions and features. So if you're
after a function, eg NETWORKDAYS, that is only accessible when you install
this add-in, you will now be able to use this function when you go to
Insert-->Function, or by typing the function directly into the cell.

HTH,
Katherine

 

[Guest]

As far as I know, after installing Analysis Toolpak, this option must be visible in Tools menu, namely you must see ...Data Analysis... I cant find it in my excel, and it doesnt work on several other computers of my friends