Excel COM add-ins can vanish from the Add-ins dialog box, leaving you unable to use critical tools. This usually happens due to a corrupted entry in the Windows Registry or a conflict with another program. This article explains why COM add-ins disappear and provides a direct method to restore them by editing the registry.
Key Takeaways: Restoring Missing COM Add-ins
- Registry Editor (regedit): The primary tool for manually restoring or disabling a missing COM add-in by editing its Windows Registry key.
- Developer > COM Add-ins dialog: The Excel interface where COM add-ins are listed and managed, which may appear empty when the registry entry is damaged.
- LoadBehavior registry value: A numeric setting that controls whether an add-in loads automatically, is disabled, or is unloaded, which you can reset to fix the issue.
Why Excel COM Add-ins Vanish from the List
COM add-ins are managed through entries in the Windows Registry, not through files in your Excel startup folder. When you install a COM add-in, Excel creates a specific key under your user profile in the registry. This key contains a critical value named LoadBehavior that tells Excel how to handle the add-in.
The add-in disappears from the list when this registry entry becomes corrupted or is deleted. Corruption can occur during a Windows update, an Office repair operation, or if the add-in’s own installer encounters an error. A conflict with another add-in or antivirus software can also cause Excel to mark the entry as invalid, effectively hiding it from the management dialog.
The Role of the LoadBehavior Value
The LoadBehavior value is the most important setting. A value of 3 means the add-in is loaded and connected when Excel starts. A value of 2 means it is loaded but not connected, which can sometimes cause it to not appear in the list. A value of 0 means the add-in is unloaded and disabled. If this value is missing or set to an unexpected number, Excel cannot properly interpret the add-in’s status, causing it to be omitted from the interface.
Steps to Re-enable a Missing COM Add-in via Registry
Editing the registry is a direct way to fix a corrupted COM add-in entry. You must know the exact name or unique identifier of the missing add-in to locate its key.
- Close Excel completely
Ensure all instances of Excel are closed. Check the Task Manager to confirm no Excel processes are running in the background. - Open the Registry Editor
Press the Windows key + R, typeregedit, and press Enter. Click Yes if prompted by User Account Control. - Navigate to the COM Add-ins registry key
In the Registry Editor, go to this path:HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins. Expand the folders in the left pane to reach the Addins folder. - Locate the specific add-in folder
Under the Addins folder, you will see subfolders for each installed COM add-in. The folder name is usually the add-in’s programmatic ID. You may need to open each folder to check the FriendlyName value to identify the correct one. - Check and modify the LoadBehavior value
Double-click the LoadBehavior value in the right-hand pane. In the Edit DWORD dialog, set the Value data to3. Click OK. If the LoadBehavior value does not exist, right-click in the right pane, select New > DWORD (32-bit) Value, name itLoadBehavior, and set its value to 3. - Verify the add-in is restored
Close the Registry Editor and open Excel. Go to the Developer tab and click COM Add-ins. Your previously missing add-in should now appear in the list with its checkbox available.
Alternative Method: Disable and Re-enable via Excel
If the add-in appears but is unchecked, you can try toggling it within Excel first. Open the COM Add-ins dialog, check the box next to the add-in, and click OK. If it fails to load, uncheck it, close Excel, reopen it, and check the box again. This process can sometimes trigger Excel to repair the registry link.
If the COM Add-in Still Does Not Appear
The Registry Key is Completely Missing
If you cannot find a folder for your add-in under the Addins registry path, the installation may have failed. You will likely need to reinstall the add-in software from its original installer. Running the installer again should recreate the necessary registry entries.
Excel Crashes When the Add-in Loads
A crash on load indicates a deeper problem with the add-in file itself. First, ensure the add-in’s main .dll or .exe file still exists on your computer. If the file is missing, reinstall the add-in. If the file exists, the add-in may be incompatible with your current version of Excel or Windows. Contact the add-in’s developer for an updated version.
Add-in Appears but Returns an Error
An error message when loading suggests the add-in’s files are present but corrupted, or a dependency is missing. Try the following steps:
- Uncheck the add-in in the COM Add-ins dialog and close Excel.
- Use the add-in’s official uninstaller via Windows Settings > Apps.
- Restart your computer and install the add-in again from a fresh download.
Registry Edit vs. Reinstall: Key Differences
| Item | Editing the Registry | Reinstalling the Add-in |
|---|---|---|
| Primary Use Case | Fixing a corrupted or misconfigured LoadBehavior value for an already installed add-in | Restoring missing registry keys and program files after a failed installation or deletion |
| Complexity | Moderate, requires navigating the Windows Registry | Simple, involves running a standard installer wizard |
| Risk Level | High, incorrect edits can affect system stability | Low, the installer manages changes |
| Data Preservation | Your add-in settings and registration typically remain intact | May reset the add-in to its default configuration |
| Speed | Fast, usually takes less than a minute | Slower, involves downloading and running setup |
You can now restore missing COM add-ins by correcting their LoadBehavior setting in the Windows Registry. For persistent issues, use the add-in’s original installer to recreate all necessary files and keys. A related advanced technique is to export a working add-in’s registry key as a backup before making system changes, allowing for quick restoration if problems occur later.