Analysis Toolpak not visible in Tool menu

R

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?
 
K

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
 
R

roman

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top