Cannot Remove Entries from Add-Ins Dialog Box (110076)

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?
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: 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
				

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: