XL: Cannot Remove Entries from Add-Ins Dialog Box

ID: Q110076

5.00 5.00c 7.00 WINDOWS kbusage

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?

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.

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

Version           : 5.00 5.00c 7.00
Platform          : WINDOWS

Last Reviewed: September 15, 1996