Add-In "Analysis ToolPack" does not work.

[Guest]

I installed that Add-In and it didn't occur in Tools Menu. When I open
Tools->Add-Ins, Analysis ToolPack is checked. What is wrong? How can I solve
it?

Regards,

 

[Bob Phillips]

It doesn't give you a menu option, it is a collection of specialist
functions.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Arvi Laanemets]

Hi

It mustn't appear there! Simply you must have some lot of additional
functions available now {p.e. NETWORKDAYS()}.

 

[Mike Middleton]

Mlody -

One way to install Analysis ToolPak is Start | Control Panel | Add or Remove
Programs | Office | Office Setup | Add or Remove Features.

Then you should be able to check the box in Excel | Tools | Add-Ins.

The new menu item in Excel 2003 and earlier versions of Excel is Tools |
Data Analysis.

In Excel 2007 the Data Analysis item appears on the Data ribbon.

The Analysis ToolPak also contains many worksheet functions.

- Mike
http://www.mikemiddleton.com