Load the Analysis ToolPak

In Excel 2010, improvements have been made to many of the functions that the Analysis ToolPak uses.
Read a blog post or try Office 365!

The Analysis ToolPak is a Microsoft Office Excel add-in program that is available when you install Microsoft Office or Excel.

To use the Analysis ToolPak in Excel, however, you need to load it first.

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

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

  3. Click Go.

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

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

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

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

Note   To include Visual Basic for Application (VBA) functions for the Analysis ToolPak, you load the Analysis ToolPak - VBA add-in the same way that you load the Analysis ToolPak. In the Add-ins available box, select the Analysis ToolPak - VBA check box, and then click OK.

Applies To: Excel 2007



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language