Microsoft KB Archive/110076

= Cannot Remove Entries from Add-Ins Dialog Box =

Article ID: 110076

Article Last Modified on 8/15/2005

-

APPLIES TO


 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 5.0c

-



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.



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.



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
 Open the EXCEL5.INI in any text editor (such as Windows Notepad). 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=

  Delete the add-in entry, and then save and close the EXCEL5.INI file.</li></ol>

To delete or move the add-in file
To delete or move the add-in file, do the following: <ol> 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.</li> 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.</li> 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?

</li> Choose OK.</li></ol>

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: <pre class="fixed_text">  HKEY_CURRENT_USER\Software\Microsoft\Excel\7.0\Init Commands <ol style="list-style-type: lower-alpha;"> Exit Microsoft Excel.</li> On the Windows 95 taskbar, click Start, and then click Run.</li> In the Run box, type regedit, and click OK.</li>  Locate the following key: <pre class="fixed_text">  HKEY_CURRENT_USER\Software\Microsoft\Excel\7.0\Init Commands </li> In the right pane, locate the entry for the add-in that you no longer want listed.</li> Click the entry and press the DELETE key. Click Yes when prompted to confirm the deletion.</li> On the Registry menu, click Exit.</li> Start Microsoft Excel.</li></ol>

The error message should no longer appear.

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

136393 How to Modify the Windows Registry

<div class="moreinformation_section">

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.

<div class="references_section">