iYogi

Computer Problems? Call Toll Free @ 1 877 316 9417
Troubleshoot all your computer problems with certified tech experts, Call Today!
http://support.iyogi.com

Question

How to install Add-Ins in Microsoft® Excel

Reason
In installing an Excel Add-In I described the protocol for installing an add-in in Excel. The protocol I described was valid for Excel 97 through 2003, but the change in user interface which came with Excel was accompanied by a more tortuous protocol. It is not really more complicated once you get used to it, but the first few times it is an adventure.

The solution to the problem

Follow the instructions to install Add-Ins in Microsoft Excel:

  1. 1

    Select the ‘Tools’ menu and select ‘Add-Ins’.

  2. 2

    If the desired Add-In is listed in the ‘Add-Ins Available’ list box, then select it.

  3. 3

    If the desired Add-In is not listed in the ‘Add-Ins Available’ list box:

    1. Click ‘Browse’.
    2. Select ‘Add-Ins (*.xla;*.xll)’ from the ‘List Files of Type’ drop-down list box.
    3. Select the drive where the Add-In file is located from the ‘Drives’ drop-down list box.
    4. Select the directory where the Add-In file is located from the ‘Directories’ interactive list box.
    5. Select the Add-In file from the ‘File Name’ list box.
    6. Click ‘OK’.
    7. Select the Add-In from the ‘Add-Ins Available’ list box.
  4. 11

    Click ‘OK’.

Footnotes:

If the add-in has been stored in one of the default add-in directories, it will appear in the list. Check the box in front of a listed add-in to install it, or uncheck the box to uninstall it. If the add-in does not appear in the list, click ‘Browse’, and use the ‘Browse’ dialog to locate the add-in file.

Leave a Reply

*