Analysis Toolpak not visible in Tool menu

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Roman J - 29 Feb 2004 13:07 GMT

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?

Reply to this Message

Katherine Coombs - 01 Mar 2004 05:54 GMT

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

> After I add analysis toolpak in Add-ins, Excell istalls
> it, but I still can't find it and access in Tools menu.
[quoted text clipped - 5 lines]
> is there any way to use the functions from Analysis
> Toolpak by typing them in?

Reply to this Message

roman - 01 Mar 2004 19:56 GMT

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

Reply to this Message