power4XL Microsoft Excel Resource Center
Free Macros, Formulas, Functions, Tutorials, Downloads, Add-Ins & More!

How do I install the Analysis ToolPak?

Installing the Microsoft Excel Analysis ToolPak is quite easy.

First, open Microsoft Excel.

Next, select "Add-Ins" from the "Tools" menu, as shown below:


This will open a window showing all available Excel add-ins, illustrated below:

Check the boxes for "Analysis ToolPak" and/or "Analysis ToolPak - VBA", as desired (see what the difference is).

Click "OK" on the dialogue box, and the ToolPak(s) will be installed and available for use.

- Return to Contents -

Copyright notice:  This site and all content, including computer code and spreadsheet examples, are copyright 2006 by Fritz Dooley.  License is granted for individual users to download examples and to copy code directly into user's spreadsheets and Visual Basic for Applications files.  Users may not redistribute code in any way.  Providing hyperlinks to this web site is encouraged, but posting code and examples on other web sites is expressly forbidden.  "Microsoft" is a registered trademark of Microsoft Corporation.   Neither this web site nor Fritz Dooley is affiliated with Microsoft Corporation.