XL: Cannot Remove Entries from Add-Ins Dialog Box

Last reviewed: September 13, 1996
Article ID: Q110076
The information in this article applies to:
  • Microsoft Excel for Windows, versions 5.0, 5.0c
  • Microsoft Excel for Windows 95, version 7.0

IMPORTANT: This article contains information about editing the registry. Before you edit the registry, you should first make a backup copy of the registry files (System.dat and User.dat). Both are hidden files in the Windows folder.

SYMPTOMS

In Microsoft Excel version 5.0, when you choose Add-Ins from the Tools menu, you cannot remove an entry from the Add-Ins Available list in the Add-Ins dialog box.

WORKAROUND

Microsoft Excel 5.x for Windows

To remove an add-in from the Add-Ins Available list, do either of the following:

  • Remove the reference to the add-in from the EXCEL5.INI file

    NOTE: This option can only be used for custom add-ins. To remove add-ins that are shipped with Microsoft Excel 5.0, follow the delete procedure in the "To delete or move the add-in file" section, later in this article).

    -or-

  • Delete or move the add-in file

To remove the reference to the add-in from the EXCEL5.INI file

  1. Open the EXCEL5.INI in any text editor (such as Windows Notepad).

  2. Locate the section of the EXCEL5.INI file that lists the add-in you want to remove as follows:

        - If the add-in you want to remove was selected in the Add-Ins
          Available list, locate the [Microsoft Excel] section of the
          EXCEL5.INI file. All add-ins that are selected in the Add-Ins
          Available list are listed in this section. The following is an
          example of a listing for the add-in MYADDIN.XLA located in the Excel
          directory:
    

             [Microsoft Excel]
             Open1=C:\Excel\myaddin.xla
    
        - If the add-in was listed but not selected in the Add-Ins Available
          list, locate the [Add-In Manager] section of the EXCEL.INI file. All
          add-ins that are listed but not selected in the Add-Ins Available
          list are listed in this section. The following is an example of an
          add-in listed in the [Add-In Manager] section:
    
             [Add-In Manager]
             C:\Excel\myaddin.xla=
    
    

  3. Delete the add-in entry, and then save and close the EXCEL5.INI file.

To delete or move the add-in file

To delete or move the add-in file, do the following:

  1. In Microsoft Excel, from the Tools menu, choose Add-Ins. In the Add-Ins Available list, clear the check box next to the add-in you want to remove and choose OK.

  2. From File Manager or an MS-DOS command prompt, delete the add-in file or move it to another directory on your hard disk drive.

  3. Switch to Microsoft Excel, and from the Tools menu, choose Add-Ins. From the Add-Ins Available list, choose the add-in you deleted or moved in step 2.

The following error message appears:

   Cannot find add-in 'C:\Excel\myaddin.xla'. Delete from list?

  • Choose OK.

    The add-in entry will be removed from the Add-Ins Available list.

    NOTE: If you delete or move a custom add-in that was selected in the Add- Ins Available list while Microsoft Excel is not running, you receive the following error message each time you start Microsoft Excel:

       Cannot Find C:\Excel\myaddin.xla
    
    
    If you delete or move an add-in that is shipped with Microsoft Excel 5.0, you will not receive the above error until you try to use an option that accesses that add-in.

    To keep this error message from being displayed, use the first workaround above to remove the reference to the add-in from EXCEL5.INI.

    Microsoft Excel for Windows 95, version 7.0

    You can remove the item from the list of add-ins by manually removing its registry entry.

    WARNING: Using Registry Editor incorrectly can cause serious problems that may require you to reinstall Windows 95. Microsoft cannot guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk.

    For information about how to edit the registry, view the Changing Keys And Values online Help topic in Registry Editor (Regedit.exe). Note that you should make a backup copy of the registry files (System.dat and User.dat) before you edit the registry.

    The registry entry that loads the add-in can also be manually removed from the following registry key:

       HKEY_CURRENT_USER\Software\Microsoft\Excel\7.0\Init Commands
    
    
    a. Exit Microsoft Excel.

    b. On the Windows 95 taskbar, click Start, and then click Run.

    c. In the Run box, type "regedit" (without the quotation marks), and click

       OK.
    
    
    d. Locate the following key:

          HKEY_CURRENT_USER\Software\Microsoft\Excel\7.0\Init Commands
    
    
    e. In the right pane, locate the entry for the add-in that you no longer
       want listed.
    
    
    f. Click the entry and press the DELETE key. Click Yes when prompted to
       confirm the deletion.
    
    
    g. On the Registry menu, click Exit.

    h. Start Microsoft Excel.

    The error message should no longer appear.

    For additional information, please see the following article(s) in the Microsoft Knowledge Base:

       ARTICLE-ID: Q136393
       TITLE     : How to Modify the Windows Registry
    
    

    MORE INFORMATION

    Add-ins are custom commands or functions that appear to be part of the Microsoft Excel application.

    To install an add-in:

    1. From the Tools menu, choose Add-ins.

    2. From the Add-ins dialog box, choose Browse, and then select the add-in you want to add. (You may need to switch to a different directory depending on where your add-in is stored.)

    Once the add-in appears in the Add-Ins Available list, you cannot remove it using the Add-In dialog box.

    REFERENCES

    "User's Guide," version 5.0, page 660


  • KBCategory: kbusage
    KBSubcategory:

    Additional reference words: 5.00 5.00c 7.00



    THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

    Last reviewed: September 13, 1996
    © 1998 Microsoft Corporation. All rights reserved. Terms of Use.