Excel add-ins can stop working, leaving you without critical tools for data analysis or reporting. This usually happens when an add-in is disabled due to a crash, a security setting, or an update conflict. This article explains how to safely restore your add-ins and get them functioning again.
Key Takeaways: Restoring Excel Add-ins
- File > Options > Add-ins: This is the main interface to manage, enable, or disable COM and Excel Add-ins.
- Developer > Add-ins: Use this tab to quickly enable or disable add-ins if the Developer tab is visible in your ribbon.
- Excel Safe Mode: Starting Excel without add-ins can help you access the settings to re-enable a problematic one.
Why Excel Add-ins Become Disabled
Excel has built-in safety features that protect your work and the application. When an add-in causes Excel to crash or become unstable, the program may automatically disable it the next time you start. This is a common safeguard. Add-ins can also be manually disabled by a user or by a group policy from an IT department. Another frequent cause is a conflict between add-ins or an outdated add-in that is not compatible with your current version of Excel.
There are two primary types of add-ins in Excel. COM Add-ins are often more complex programs that integrate deeply with Excel, like PDF creators or advanced data connectors. Excel Add-ins are typically simpler, containing custom functions, ribbon tabs, or templates. The process for re-enabling them is similar, but they are managed in slightly different lists within the same dialog box.
Steps to Re-Enable Your Add-ins
Follow these steps to check the status of your add-ins and turn them back on. It is best to start Excel normally first.
- Open the Excel Options window
Click File in the top-left corner of Excel. Then select Options from the bottom of the left-hand menu. - Navigate to the Add-ins section
In the Excel Options dialog box, click on the Add-ins category on the left sidebar. You will see a list of your active and inactive add-ins at the bottom. - Check the add-in lists
Look at the Manage dropdown box at the bottom. Ensure it says COM Add-ins and click Go. A new dialog box will open showing your COM Add-ins. Check the box next to any disabled add-in you wish to enable and click OK. - Check for Excel Add-ins
Return to the Add-ins screen in Excel Options. Change the Manage dropdown to Excel Add-ins and click Go. Check the boxes for any add-ins you need in this list and click OK. - Restart Excel
Close Excel completely and reopen it. Your newly enabled add-ins should now appear on the ribbon or be available for use.
Using the Developer Tab
If the Developer tab is already enabled on your ribbon, you can use a faster method.
- Go to the Developer tab
Click the Developer tab on the Excel ribbon. - Click Excel Add-ins or COM Add-ins
In the Add-ins group, click either the Excel Add-ins or COM Add-ins button. This opens the same dialog boxes as the File > Options method. - Enable the add-ins
Check the boxes for the add-ins you want and click OK. You may need to restart Excel for the changes to take full effect.
If Your Add-in Still Does Not Work
Excel Crashes Immediately After Enabling an Add-in
If Excel crashes as soon as you enable a specific add-in, that add-in is likely corrupted or incompatible. Start Excel in Safe Mode by holding the Ctrl key while clicking the Excel icon. In Safe Mode, go to File > Options > Add-ins and disable the problematic add-in. Then visit the add-in vendor’s website to check for an updated version that is compatible with your Excel release.
Add-in is Missing From the List Entirely
If an add-in is not listed in the COM or Excel Add-ins dialog, it may not be properly installed. You will need to reinstall it. Close Excel, run the add-in’s original installer program, and then restart Excel. The add-in should appear in the list and can be enabled.
The Add-in Button is Grayed Out or Inactive
Some add-ins require specific files or references to be present. If the add-in’s button on the ribbon is grayed out, the add-in may be looking for a data source or template that has been moved. Check the add-in’s documentation for file path requirements. Also, ensure macros are enabled in File > Options > Trust Center > Trust Center Settings > Macro Settings.
COM Add-ins vs. Excel Add-ins: Key Differences
| Item | COM Add-ins | Excel Add-ins |
|---|---|---|
| File Extension | .dll or .exe | .xlam, .xla |
| Installation | Often requires a separate installer | Can be loaded directly from an Excel file |
| Integration Depth | Deep system-level integration | Primarily functions and ribbon customizations |
| Management Location | File > Options > Add-ins > COM Add-ins | File > Options > Add-ins > Excel Add-ins |
| Common Use | PDF tools, database connectors, advanced analytics | Custom formulas, template galleries, simple tools |
You can now successfully restore most disabled Excel add-ins through the Options menu. If one add-in continues to fail, try enabling your others first to isolate the problem. For persistent issues, use the Trust Center settings to adjust macro security levels, which can sometimes block add-in functionality.