Fix an Excel COM Add-in That Becomes Inactive After Startup
Question details
Restore an Excel COM add-in that becomes inactive after Office starts but works when manually enabled.

- Product
- Microsoft Excel COM add-ins
- Device & OS
- Windows
- Scenario
- An Excel user needs a COM add-in to load automatically on a corporate-managed Office installation.
- Observed behavior
- The add-in is inactive after startup but works when enabled manually.
Identify the affected add-in and note when the issue began. In Excel, check File > Account for the Office version and build, and select About Excel to check whether Office is 32-bit or 64-bit.
Enable the COM add-in and check its startup settings
Use Excel's add-in controls and the Windows registry to check whether the add-in is allowed to load at startup.
In Excel, go to File > Options > Add-ins. Select COM Add-ins in the Manage list, click Go, check the affected add-in, and click OK.
On the same Add-ins page, select Disabled Items in the Manage list and click Go. If the affected add-in appears, select it and click Enable.
Close all Excel windows, reopen Excel, and return to File > Options > Add-ins to see whether the add-in remains active.
If it becomes inactive again, ask your administrator to open Registry Editor and check the add-in's key under HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins or the corresponding HKEY_LOCAL_MACHINE location. A LoadBehavior value of 3 normally indicates that the add-in is set to load at startup.

Repair the add-in and confirm Office build compatibility
Use this approach if the add-in still becomes inactive, especially if the issue started after an Office update.
Work with spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Microsoft Office file formats, making it easy to move everyday documents between applications. It does not fix an Excel COM add-in issue.

Frequently Asked Questions
Where can I see whether my Excel COM add-in is active?
Go to File > Options > Add-ins. Review the active and inactive add-in lists, or select COM Add-ins in the Manage list and click Go to check its status.
Why does the add-in work when I enable it manually but not at startup?
Its startup load setting may be incorrect, or Excel may have stopped it from loading after a failure. Check its LoadBehavior registry value with your administrator and ask the vendor about compatibility with your Office build.
What does LoadBehavior 3 mean for an Excel add-in?
A LoadBehavior value of 3 normally means the add-in is set to load when Excel starts. This setting alone does not guarantee a successful load if the add-in encounters an error.
Should I change my Office version to fix the add-in?
Not without checking first. If the Office build is managed by your organization, contact desktop engineering and the add-in vendor to confirm compatibility and approved options.
Can WPS Office fix an Excel COM add-in?
No. The add-in must be troubleshot in Microsoft Excel and Windows. WPS Office is an alternative for working with compatible spreadsheet files, not a repair tool for Excel COM add-ins.




