Analysis Tool Pak

I need to install Analysis Tool Pak for Excel.  I have Windows Vista, the steps online state that I can go to the Windows Icon and select Excel Options.  I can't find an Excel Options, another forum said that I need to uninstall my program and then when I reinstall the program I select the add in options.  I can't find my cd, is there any other way to add the Tool Pak or is there something out there that can run a regression? 
Answer
Answer

Excel:

 

http://answers.microsoft.com/en-us/office/default.aspx


Office Forums at above link


http://answers.microsoft.com/en-us/office/ee861099.aspx

 

Excel Help Forums at above link

They will help you with your Excel questions when you repost in the above Office Forums.

 

Cheers.


Mick Murphy - Microsoft Partner

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Answer
Answer

Try following steps if you have installed Excel 2003:-

1.       On the Tools menu, click Add-Ins.

2.       In the Add-Ins available box, select the check box next to Analysis Toolpak, and then click OK.

Note:-  If Analysis Toolpak is not listed, click Browse to locate it.

If you see a message that tells you the Analysis Toolpak is not currently installed on your computer, click yes to install it.

Click Tools on the menu bar. When you load the Analysis Toolpak, the Data Analysis command is added to the Tools menu.

Note:-  To include Visual Basis for Application (VBA) functions for the Analysis Toolpak, you can load the Analysis Toolpak - VBA Add-in the same way you load the Analysis Toolpak. In the Add-ins available box, select the check box next to Analysis Toolpak - VBA.

For more information refer: - http://office.microsoft.com/en-us/excel/HP011277241033.aspx

 

 

Try following steps if you have installed Excel 2007 :-

 

1.       Click the Microsoft Office Button, and then click Excel Options.

2.       Click Add-Ins, and then in the Manage box, select Excel Add-ins.

3.       Click Go.

In the Add-Ins available box, select the Analysis ToolPak check box, and then click OK.

Note: - If Analysis ToolPak is not listed in the Add-Ins available box, click Browse to locate it.

If you get prompted that the Analysis ToolPak is not currently installed on your computer, click Yes to install it.

4.       After you load the Analysis ToolPak, the Data Analysis command is available in the Analysis group on the Data tab.

For more information refer: - http://office.microsoft.com/en-us/excel/HP100215691033.aspx

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated October 5, 2021 Views 14 Applies to: