Troubleshoot a C# COM Add-In That Loads in Excel Without Functions
Question details
The user needs to diagnose why a C# COM add-in runs from the development environment but loads in Microsoft Excel without exposing its functions and without showing visible errors.

- Product
- Microsoft Excel COM Add-In
- Device & OS
- not provided
- Scenario
- A developer launches a C# COM add-in successfully in the development environment, but when the same add-in is opened in Excel, its functions are missing.
- Observed behavior
- The add-in loads in Excel but its functions are unavailable, with no visible error or warning.
Before troubleshooting, close all Excel processes and note whether Excel is 32-bit or 64-bit from File > Account > About Excel. Confirm the COM add-in's target CPU and .NET Framework version so you can compare them during the checks.
Check Excel Bitness, Disabled Items, and COM Add-In Load State
Start here when the add-in loads but its functions are missing, because silent disabled items or an architecture mismatch are the most common causes.
Excel can disable a COM add-in after a startup failure without showing a warning. A COM add-in built for x86 cannot load into 64-bit Excel, and a .NET Framework mismatch can also prevent the exposed functions from appearing.
In Excel, click File > Options > Add-ins. Keep this window open so you can switch between COM Add-ins and Disabled Items.
At the bottom of the Add-ins window, set Manage to Disabled Items and click Go. If the add-in is listed, select it and choose Enable.
Return to File > Options > Add-ins, set Manage to COM Add-ins and click Go. Confirm that the add-in's checkbox is selected in the Available add-ins list.
Open File > Account > About Excel. The version text shows either 32-bit or 64-bit; compare this with the add-in's build platform.
If a bitness or .NET Framework mismatch is found, unregister the current COM add-in and register the matching x86 or x64 build, then restart Excel and test the functions.

Capture Silent Load Failures with Excel and .NET Assembly Logging
Use this method when the add-in is enabled and the bitness matches, but the functions still do not appear in Excel.
Repair COM Registration and Automation-Visible Classes
Use this if the add-in loads in the COM Add-ins list but its functions remain unavailable, which points to registration or class visibility problems.
Switch to WPS Office for Reliable Spreadsheet Work Without Excel COM Add-In Issues
WPS Office is a free, lightweight Office suite that opens and edits Microsoft Excel workbooks while avoiding Excel-specific COM add-in registration problems. It offers a familiar ribbon interface, strong format compatibility, and easy migration from Microsoft Office files.

Frequently Asked Questions
Why does my Excel COM add-in work from Visual Studio but not when I open Excel normally?
Visual Studio may launch a different Excel bitness or load context. Check File > Options > Add-ins, review Disabled Items, and compare the add-in's target CPU with Excel's 32-bit or 64-bit version.
How do I know if Excel disabled my COM add-in?
Open File > Options > Add-ins, set Manage to Disabled Items, and click Go. If the add-in appears there, select it and choose Enable, then restart Excel.
Where can I see whether Excel is 32-bit or 64-bit?
Click File > Account > About Excel. The About Microsoft Excel dialog text says either 32-bit or 64-bit.
What should I check if the COM add-in is enabled but functions still do not appear?
Check that the exposed C# classes are public and marked ComVisible, that the Excel add-in registration key has LoadBehavior set to 3, and that all dependencies are installed on the target machine.
Can WPS Office run Microsoft Excel COM add-ins?
WPS Office is not designed to run Excel-specific COM add-ins. It can open and edit Excel workbooks as a free alternative without COM add-in registration.




