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

Installing the Analysis ToolPak in Excel 2003 (and earlier)


The Analysis ToolPak is a free resource from Microsoft that provides several functions useful in statistical analysis of Monte Carlo results.  The toolpak comes with Excel; it generally does not require a separate download.  However, it is not installed by default when you install Microsoft Office.

Brief installation instructions are provided here.  A list of the available functions, as well as additional information, is available at www.analysistoolpak.com

Installing the Analysis ToolPak is quite simple in Excel 2003 and earlier.  First, select "Add-Ins" from the "Tools" menu, as shown below.


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

Check the boxes for both "Analysis ToolPak" and "Analysis ToolPak - VBA".  Click "OK", and you're done.

If you de-selected Analysis ToolPak when you originally installed Microsoft Excel, you may need your MS Office or MS Excel installation disc in order install the toolpaks.


Prev | Contents | Next

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.