Your Excel add-ins disappear or show as disabled each time you restart the application. This happens because a specific Windows registry key is corrupted or has incorrect permissions. The registry controls which add-ins Excel is allowed to load. This article explains how to locate and fix the problematic registry entry to permanently resolve the issue.
Key Takeaways: Fixing the Registry for Persistent Excel Add-ins
- Registry Editor (regedit): The tool you use to navigate to and modify the specific key that controls Excel add-in loading behavior.
- HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel\Options: The primary registry path where the list of enabled add-ins is stored for your user account.
- Take Ownership permission: A security setting you must apply to the registry key if you cannot modify it due to permission restrictions from system policies or previous installations.
Why the Registry Causes Add-ins to Disable
Excel stores a list of your enabled add-ins in the Windows registry. When you check an add-in in the File > Options > Add-ins dialog, Excel writes an entry for it in a specific location. If this registry key becomes corrupted, has the wrong security permissions, or is being reset by another process, Excel cannot read the saved list on startup. The application then defaults to a state where all add-ins are disabled. This is a common problem after major Windows updates, Office repairs, or when user profile permissions change.
How Other Factors Interfere
Group Policy settings from a workplace IT department can enforce specific add-in states, overriding your local registry settings. Antivirus software with deep Office integration may quarantine or lock registry keys it deems suspicious. Furthermore, having multiple versions of Office installed can cause conflicts where one version’s installer resets registry keys for another.
Steps to Fix the Registry Key and Permissions
Follow these steps to correct the registry entry that manages your Excel add-ins. You will need administrative rights on your computer.
- Open Registry Editor
Press the Windows key + R, typeregedit, and press Enter. Click Yes if prompted by User Account Control. - Navigate to the Excel Options Key
In the left pane, navigate to this path:HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel\Options. The “16.0” corresponds to Office 2016, 2019, and Microsoft 365. For Office 2013, use “15.0”. - Check for the OPEN Registry Value
Look in the right pane for a value namedOPEN. This REG_SZ value contains the file paths of your enabled add-ins. If it is missing, the problem is likely elsewhere. If it exists, note its data or proceed to the next step. - Take Ownership of the Key (If Needed)
Right-click theOptionsfolder in the left pane and select Permissions. Click Advanced. Next to the “Owner” field, click Change. Enter your username, click Check Names, and then OK. Check the box for “Replace owner on subcontainers and objects” and click Apply. Close all permission windows. - Grant Full Control Permissions
Right-click theOptionsfolder again and select Permissions. Select your user name from the list. In the permissions box below, check the box forFull Controlunder Allow. Click Apply and then OK. - Restart Excel and Re-enable Add-ins
Close Registry Editor and restart Excel. Go to File > Options > Add-ins. At the bottom, next to Manage, select “COM Add-ins” and click Go. Re-check the boxes for your add-ins and click OK.
If Add-ins Still Disable After Registry Fix
Excel Add-ins Disabled by Group Policy
Your workplace IT may use Group Policy to control add-ins. Open the Local Group Policy Editor (gpedit.msc) and navigate to User Configuration > Administrative Templates > Microsoft Excel 2016 > Excel Options > Security > Trust Center > Add-ins. Check if policies like “List of managed add-ins” are configured. You may need to contact your system administrator.
Add-in File Itself is Blocked
Windows may be blocking the add-in file. Locate the .xlam or .dll file for the add-in, right-click it, and select Properties. If there is an “Unblock” checkbox on the General tab, check it and click Apply. This removes the security marker from files downloaded from the internet.
Conflict with Another Office Application
An add-in that loads in both Excel and Word might be failing in Word and affecting Excel. Open Word and check its add-in manager via File > Options > Add-ins. Disable the same add-in there, restart your computer, and then try enabling it only in Excel first.
Manual Registry Edit vs. Office Repair: Key Differences
| Item | Manual Registry Edit | Office Quick Repair |
|---|---|---|
| Primary Use Case | Fixing corrupted or permission-locked registry keys specific to add-ins | Fixing general Office installation errors or missing files |
| Complexity | Higher risk, requires precise navigation | Simple, automated process |
| Data Risk | Potential for system instability if done incorrectly | Very low, does not affect documents or settings |
| Effect on Problem | Directly addresses the root cause of add-in disabling | May temporarily fix it if the issue was a damaged Office binary |
| Time Required | 5-10 minutes | 10-15 minutes plus restart |
You can now stop your Excel add-ins from disabling automatically. The solution involves correcting permissions for a specific registry key under the Excel Options path. If the problem persists, check for file blocking or Group Policy settings. For advanced users, creating a registry backup before editing allows for a quick restore if any other Office functions are accidentally affected.