Office Settings & Configuration

Troubleshoot a C# COM Add-In That Loads in Excel Without Functions

Rana GarciaRana Garcia Nov 13, 2026 869 views

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.

Troubleshoot a C# COM Add-In That Loads in Excel Without Functions
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 you start

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.

Solution 1Recommended

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.

1
Open Excel Add-ins options

In Excel, click File > Options > Add-ins. Keep this window open so you can switch between COM Add-ins and Disabled Items.

2
Check 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.

3
Open COM Add-ins list

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.

4
Check Excel bitness

Open File > Account > About Excel. The version text shows either 32-bit or 64-bit; compare this with the add-in's build platform.

5
Register the matching build

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.

Check Excel Bitness, Disabled Items, and COM Add-In Load State
Expected result: When the bitness and load state are correct, Excel enables the COM add-in and its functions appear under the Add-Ins tab or in the Excel function list.
Free Microsoft Office alternative

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.

Free and lightweight Office suite that reduces complex COM add-in troubleshootingOpens and edits .xlsx, .xls, and .csv workbooks with Microsoft Excel format compatibilityFamiliar ribbon interface and shortcuts help you switch from Microsoft Excel quicklySeamless migration of existing Excel workbooks and templates into WPS OfficeBuilt-in spreadsheet, writer, presentation, and PDF tools in one download
microsoft office alternative - wps office

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.