Load or unload add-in programs

1. On the Tools menu, click Add-Ins.

   Load an add-in

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

   2. In the Add-Ins available box, select the check box next to the add-in you want to load, and then click OK.
   3. If necessary, follow the instructions in setup program.

   Unload an add-in

   1. In the Add-Ins available box, clear the check box next to the add-in you want to unload, and then click OK.
   2. Do one of the following:
      • To remove the add-in from the menu, restart Excel.

        Note  Unloading or removing an add-in doesn't remove the add-in file from your disk.

      • To remove the add-in from your disk, uninstall it (Microsoft Office, Microsoft Excel for Windows, Add-Ins).

        How?

        If you originally installed your Microsoft Office program from a network file server or from a shared folder, you must install or remove components from that location. If you installed your Office program from a CD-ROM and you've mapped your CD-ROM drive to a new drive letter since installing the Office program, reinstall from the CD-ROM. If you're running any Office program files from the CD-ROM, you must uninstall the Office program and then reinstall it from the CD-ROM.

        1. Quit all programs.
        2. Double-click the Add/Remove Programs icon in the Windows Control Panel.
        3. Do one of the following:

           If you installed your Office program as part of Microsoft Office, click Microsoft Office in the Currently installed programs box, and then click the Change button.

           If you installed your Office program individually, click the name of your program in the Currently installed programs box, and then click the Change button.

        4. Follow the instructions on the screen.

Developers    You can use this procedure to load or unload a COM add-in for testing before you have designed installation and removal programs for your add-in.

Other users of Microsoft Excel    If you are not a developer, you should not need to use this procedure. Contact the administrator who provided the add-in if you want installation and removal instructions.

• Do one of the following:

  Load a COM add-in

  1. On the View menu, point to Toolbars, and then click Customize.

  2. Click the Commands tab.

  3. Under Categories, click Tools.

  4. Under Commands, click COM Add-Ins and drag your selection to the toolbar.

  5. Click COM Add-Ins on the toolbar to see a list of the available add-ins in the COM Add-Ins dialog box.

  Unload a COM add-in

  • Do one of the following:

    • To unload an add-in from memory but keep its name in the list, clear the check box next to its name in the COM Add-in dialog box, and then click OK.

      Note  Unloading or removing an add-in doesn't remove the add-in file from your computer.

    • To remove an add-in from the list and from your disk, click the add-in name, and then click Remove.

Developers    You can use this procedure to load or unload an automation program before you have designed installation and removal programs for your add-in.

Other users of Microsoft Excel    If you are not a developer, you should not need to use this procedure. Contact the administrator who provided the add-in if you want installation and removal instructions.

1. On the Tools menu, click Add-Ins.
2. Do one of the following:

   Load an automation add-in

   1. Click Automation on the Add-Ins dialog box.

   2. In the Automation servers available list, select the add-in you want, and then click OK.

      Note  Not all automation servers in the list can be installed as automation add-ins.

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

   Unload an automation add-in

   Automation add-ins must be removed from the registry. See your system administrator for details.