Load the Analysis Toolpak

Important notice for users of Office 2003    To continue receiving security updates for Office, make sure you're running Office 2003 Service Pack 3 (SP3). The support for Office 2003 ends April 8, 2014. If you’re running Office 2003 after support ends, to receive all important security updates for Office, you need to upgrade to a later version such as Office 365 or Office 2013. For more information, see Support is ending for Office 2003.

The Analysis Toolpak is an Excel add-in (add-in: A supplemental program that adds custom commands or custom features to Microsoft Office.) program that is available when you install Microsoft Office or Excel. To use it in Excel, however, you need to load it first.

  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.

Tip    If Analysis Toolpak is not listed, click Browse to locate it.

  1. If you see a message that tells you the Analysis Toolpak is not currently installed on your computer, click Yes to install it.
  2. 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.

Applies to:
Excel 2003