Article ID: 110076 - Last Review: August 15, 2005 - Revision: 1.3

Cannot Remove Entries from Add-Ins Dialog Box

Retired KB ArticleRetired KB Content Disclaimer
View products that this article applies to.
System TipThis article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.
This article was previously published under Q110076
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.

On This Page

Expand all | Collapse all

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.
Back to the top

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
Back to the top

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.
Back to the top

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?
  4. 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.
Back to the top

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
  1. Exit Microsoft Excel.
  2. On the Windows 95 taskbar, click Start, and then click Run.
  3. In the Run box, type regedit, and click OK.
  4. Locate the following key: 
       HKEY_CURRENT_USER\Software\Microsoft\Excel\7.0\Init Commands
  5. In the right pane, locate the entry for the add-in that you no longer want listed.
  6. Click the entry and press the DELETE key. Click Yes when prompted to confirm the deletion.
  7. On the Registry menu, click Exit.
  8. Start Microsoft Excel.
The error message should no longer appear.

For additional information, please see the following article(s) in the Microsoft Knowledge Base:
136393  (http://support.microsoft.com/kb/136393/EN-US/ ) How to Modify the Windows Registry
Back to the top

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.
Back to the top

REFERENCES

"User's Guide," version 5.0, page 660
Back to the top
APPLIES TO
  • Microsoft Excel 95 Standard Edition
  • Microsoft Excel 5.0c
Back to the top
Keywords: 
KB110076
Back to the top
Retired KB ArticleRetired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
Back to the top