Add or remove add-ins

Add-ins provide optional commands and features for Microsoft Excel. By default, add-ins are not immediately available in Excel, so you must first install and (in some cases) activate these add-ins so that you can use them.

What do you want to do?


Learn about add-ins

Some add-ins are built in to Excel, such as Solver and the Analysis ToolPak. Some other add-ins are available from the Download Center at Office.com, and must first be downloaded and installed. Finally, there are add-ins that are created by third parties, such as a programmer in your organization or a software solution provider. These can be 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.) add-ins, Visual Basic for Applications (VBA) add-ins, and DLL add-ins. These add-ins must also be installed in order to use them.

Most add-ins can be categorized into three different types:

After you have installed or activated an add-in, the add-in and its commands may be available in one of the following locations:

  • Data tab. After you install and activate the Analysis ToolPak and Solver add-ins, the Data Analysis and Solver commands are available in the Analysis group.

Analysis group on the Data tab

  • Formulas tab. After you install and activate the Euro Currency Tools, the Euro Conversion and Euro Formatting commands are displayed in the Solutions group.

Solutions group on the Formulas tab

  • Add-Ins tab. Other add-ins may be added to the Add-Ins tab. This tab is added to the ribbon when you install and activate the first add-in that is shown in the Add-Ins tab. If you don't see the Add-Ins tab, you should exit and then restart Excel.

Other add-ins, such as the Get Started tab, are available in other places in Excel, such as a tab on the ribbon, or through macros or customized menus.

Top of Page Top of Page

Add or remove an Excel add-in

Important    If you are a software developer, you can use this procedure to install or remove an automation program before you design installation and removal programs for your add-in.

To activate an Excel add-in    

  1. Click the File tab, click Options, and then click the Add-Ins category.
  2. In the Manage box, click Excel Add-ins, and then click Go. The Add-Ins dialog box appears.
  3. In the Add-Ins available box, select the check box next to the add-in that you want to activate, and then click OK.

If you cannot find the add-in that you want to activate in the Add-Ins available box, you may need to install it.

To install an Excel add-in    

  • To install an add-in that is typically installed with Excel, such as Solver or the Analysis ToolPak, run the setup program for Excel or Microsoft Office and choose the "Change" option to install the add-in. After you restart Excel, the add-in should appear in the Add-Ins available box.
  • Some Excel add-ins are located on your computer and can be installed or activated by clicking Browse (in the Add-Ins dialog box) to locate the add-in, and then clicking OK.
  • Some Excel add-ins require running an installation package. You may need to download or copy the installation package to your computer (an installation package is typically a file with an .msi file name extension), and then run it.
  • Other add-ins that are not available on your computer can be downloaded and installed through a Web browser from Downloads at Office.com, or from other sites on the Internet or a server in your organization. Follow the setup instructions for the download as needed.

To inactivate an Excel add-in    

  1. Click the File tab, click Options, and then click the Add-Ins category.
  2. In the Manage box, click Excel Add-ins, and then click Go.
  3. In the Add-Ins available box, clear the check box next to the add-in that you want to inactivate, and then click OK.

In many cases, when you inactivate an add-in, it is removed from its group on the ribbon. In other cases, to remove the add-in from the ribbon, you may need to restart Excel.

Note    Inactivating an add-in does not remove the add-in from your computer. To remove the add-in from your computer, you must uninstall it.

To remove an Excel add-in    

Important    If you originally installed the Excel add-in from a network file server or from a shared folder, you might need to remove the add-in from that location. If you installed the Excel add-in from a CD-ROM and you mapped your CD-ROM drive to a new drive letter after installing the add-in, you need to reinstall the add-in from the CD-ROM. If you are running any Excel add-ins from the CD-ROM, you must uninstall the Excel add-ins, and then reinstall them from the CD-ROM.

  1. Exit Excel (click the File tab, and then click Exit).
  2. In Windows Vista, click the Start button Button image, 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.

  1. 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.
    • If you installed the add-in from the Download Center at Office.com, click the name of your program in the list of installed programs, and then click the Uninstall button.
  2. Follow the instructions in the installation program.

Top of Page Top of Page

Add or remove a COM add-in

Important    If you are a software developer, you can use this procedure to install or remove 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.

Add a COM add-in

  1. Click the File tab, click Options, and then click the Add-Ins category.
  2. In the Manage box, click COM Add-ins, and then click Go. The COM Add-Ins dialog box appears.
  3. In the Add-Ins available box, select the check box next to the add-in that you want to install, 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.

Remove a COM add-in

  1. Click the File tab, click Options, and then click the Add-Ins category.
  2. In the Manage box, click COM Add-ins, and then click Go. The COM Add-Ins dialog box appears.
  3. In the Add-Ins available box, clear the check box next to the add-in that you want to remove, and then click OK.

Note    This removes 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.

  1. 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 Top of Page

Add or remove an automation add-in

Important    If you are a software developer, you can use this procedure to install or remove 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 File tab, click Options, and then click the Add-Ins category.
  2. In the Manage box, click Excel Add-ins, and then click Go. The Add-Ins dialog box appears.
  3. To install an automation add-in, in the Automation servers available box, click Automation and then click the add-in that you want.

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

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

Top of Page Top of Page

 
 
Applies to:
Excel 2010