Load the Analysis ToolPak

The Analysis ToolPak is a Microsoft Office 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. 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.
4. In the Add-Ins available box, select the Analysis ToolPak check box, and then click OK.

Tip  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.

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.

Related Office Online discussions

Read related questions and answers from other Microsoft Office customers.

• How do I install the Data Analysis Toolkit from Office Basic CD?
• With Student and Teacher Edition, can I add analysis tool pack?
• How can you access Data Analysis Plus for MS Excel?
• Where is the Analysis Group in Excel?

See Also

• Load the Solver Add-in

 

 

Excel > Add-ins

Load or unload add-in programs

Excel 2007

There are different types of add-in programs for Microsoft Office Excel that provide optional commands and features:

• Excel add-ins, such as the Analysis ToolPak and the Solver Add-in, are available when you install Microsoft Office or Excel.
• Additional add-ins for Excel can be downloaded from Downloads on Microsoft Office Online.
• Developers and solution providers usually design custom Component Object Model (COM) add-ins (COM add-in: A supplemental program that extends the capabilities of a Microsoft Office program by adding custom commands and specialized features. COM add-ins can run in one or more Office programs. COM add-ins use the file name extension .dll or .exe.) and automation add-ins.

You must load an add-in before you can use it. After loading the add-in, the add-in program and its commands are available in one of the following locations:

• Data tab. The Analysis ToolPak and Solver Add-in are displayed in the Analysis group.
• Formulas tab. The Conditional Sum Wizard, Euro Currency Tools, Eurotool, and Lookup Wizard are displayed in the Solutions group.
• Add-Ins tab. The Add-Ins tab is added to the Ribbon, a component of the Microsoft Office Fluent user interface, when you load the first add-in for that tab. If you don't see the Add-Ins tab, you should exit Excel and restart it.

What do you want to do?

Load or unload an Excel add-in program

Load or unload a COM add-in program

Load or unload an automation add-in program

Load or unload an Excel add-in program

1. Click the Microsoft Office Button , and then click Excel Options.
2. Click the Add-Ins category.
3. In the Manage box, click Excel Add-ins, and then click Go.
4. To load an Excel add-in, do the following:
   1. In the Add-Ins available box, select the check box next to the add-in that you want to load, and then click OK.

Tip  If the add-in that you want to use is not listed in the Add-Ins available box, click Browse, and then locate the add-in. Add-ins that are not available on your computer can be downloaded from Downloads on Office Online.

2. If the add-in is not currently installed on your computer, click Yes to install it.

Tip  Follow the setup instructions as needed.

5. To unload an Excel add-in, do the following:
   1. In the Add-Ins available box, clear the check box next to the add-in that you want to unload, and then click OK.
   2. To remove the add-in from the Office Fluent Ribbon, restart Excel.

 Note    Unloading or removing an add-in from the Ribbon does not delete the add-in from your computer. To delete the add-in from your computer, you must uninstall it.

How to uninstall an add-in

1. Quit all programs.
2. In Windows Vista, click the Start button , click Control Panel, click Programs, and then click Programs and Features.

In Microsoft Windows XP, click the click the Start button, click Control Panel, and then double-click Add/Remove Programs.

3. Do one of the following:

If you installed Excel as part of Microsoft Office, click Microsoft Office in the list of installed programs, and then click the Change button.

If you installed Excel individually, click the name of your program in the list of installed programs, and then click the Change button.

4. Follow the instructions on the screen.

 Top of Page

Load or unload a COM add-in program

Important  If you are a developer, you can use this procedure to load or unload a COM add-in before you design installation and removal programs for your add-in. If you are not a developer, you should not need to use this procedure. Contact the system administrator who provided the add-in if you want installation and removal instructions.

1. Click the Microsoft Office Button , and then click Excel Options.
2. Click the Add-Ins category.
3. In the Manage box, click COM Add-ins, and then click Go.
4. To load a COM add-in, in the Add-Ins available box, select the check box next to the add-in that you want to load, and then click OK.

Tip  If the add-in that you want to use is not listed in the Add-Ins available box, click Add, and then locate the add-in.

5. To unload a COM add-in, do one of the following:
   • In the Add-Ins available box, clear the check box next to the add-in that you want to unload, and then click OK.

 Note    This unloads the add-in from memory but keeps its name in the list of available add-ins. It does not delete the add-in from your computer.

• To remove a COM add-in from the list of available add-ins and to delete the add-in from your computer, click its name in the Add-ins available box, and then click Remove.

 Top of Page

Load or unload an automation add-in program

Important  If you are a developer, you can use this procedure to load or unload an automation program before you design installation and removal programs for your add-in. If you are not a developer, you should not need to use this procedure. Contact the system administrator who provided the add-in if you want installation and removal instructions.

1. Click the Microsoft Office Button , and then click Excel Options.
2. Click the Add-Ins category.
3. In the Manage box, click Excel Add-ins, and then click Go.
4. To load an automation add-in, click Automation, and then click the add-in that you want in the Automation servers available box.

Tip  If the add-in that you want isn't in the list, click Browse, locate the add-in, and then click OK.

5. To unload an automation add-in, you must remove it from the registry. See your system administrator for details.

 Top of Page

 

 

Excel > Add-ins

Load the Solver Add-in

Excel 2007

The Solver Add-in is a Microsoft Office 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. 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.
4. In the Add-Ins available box, select the Solver Add-in check box, and then click OK.

Tip  If Solver Add-in is not listed in the Add-Ins available box, click Browse to locate the add-in.

If you get prompted that the Solver Add-in is not currently installed on your computer, click Yes to install it.

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