XL2000: Cannot Delete Entries from Add-Ins Dialog Box (211956)



The information in this article applies to:

  • Microsoft Excel 2000

This article was previously published under Q211956
IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows Registry


SYMPTOMS

When you click Add-Ins on the Tools menu, you may be unable to delete an item from the Add-Ins available list in the Add-Ins dialog box.

CAUSE

This behavior can occur if you load an add-in from an earlier version of Microsoft Excel, or if you add a third-party add-in, and then you click to clear the check box in the Add-ins window (and thereby unload the add-in). When you unload an add-in, you do not remove it from your computer, and some add-ins remain listed in the Add-Ins available list in the Add-Ins dialog box even after you unload them.

RESOLUTION

WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.

You can remove an item from the Add-Ins available list by manually removing its registry entry.

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

\HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Excel\Add-in Manager

To remove an add-in from the Add-Ins available list, follow these steps:
  1. Quit Microsoft Excel.
  2. Click Start, and then click Run.
  3. In the Run box, type regedit and click OK.
  4. Locate the registry key listed near the top of the "Resolution" section.
  5. In the right pane of the Registry Editor window, locate the entry for the add-in that you no longer want listed.

    NOTE: Do not remove the entry named "Default."
  6. Click the entry for the add-in that you no longer want listed, press DELETE, and then click Yes when prompted to confirm the deletion.
  7. On the Registry menu, click Exit.

REFERENCES

For additional information about modifying the Windows registry, click the article number below to view the article in the Microsoft Knowledge Base:

136393 How to Modify the Windows Registry

For additional information about removing add-ins in earlier versions of Excel, click the article number below to view the article in the Microsoft Knowledge Base:

110076 XL: Cannot Remove Entries from Add-Ins Dialog Box


Modification Type:MajorLast Reviewed:9/27/2003
Keywords:kbprb KB211956