Fix an Inactive Excel COM Add-In Created by a Signed XLL
Question details
The user needs to activate a dynamically created Excel COM add-in that remains inactive even though its parent XLL is signed and stored in a trusted location.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A signed XLL creates a COM add-in for custom Excel functions.
- Observed behavior
- The dynamically created COM add-in remains inactive and Excel reports that macros were disabled.
Confirm that the XLL is signed and identify the COM add-in it creates. Ask your IT administrator whether your organization requires application add-ins to be signed by a trusted publisher.
Verify the Generated Add-In’s Signature and Publisher
Use this approach when Excel requires application add-ins to be signed by a trusted publisher.
The XLL’s signature does not automatically sign a separate add-in that it creates. A trusted file location also does not necessarily satisfy Excel’s trusted-publisher requirement for that add-in.
In Excel, open File > Options > Add-ins. Select COM Add-ins in the Manage list, click Go, and identify the dynamically created add-in.
Open File > Options > Trust Center > Trust Center Settings > Add-ins and check whether “Require Application Add-ins to be signed by Trusted Publisher” is enabled.
Ask the add-in developer to identify the generated add-in’s executable component and verify whether it has a valid digital signature. If it has no physical file, ask the developer how the component is registered and how Excel’s signing requirement applies.
Have the developer sign the applicable add-in component, then work with your administrator to trust its publisher according to your organization’s policy. Reinstall or reload the add-in and restart Excel.

Review Excel Add-In Security Settings With Your Administrator
Use this option if signing the generated component is not currently possible and your organization permits a security-setting change.
Work With Excel Files in WPS Office
WPS Office is a free, lightweight Office alternative with a familiar spreadsheet interface and support for Microsoft Excel formats, making it easy to move everyday workbook tasks. It does not fix Excel’s add-in security settings.

Frequently Asked Questions
Why is the COM add-in inactive if the XLL is signed?
The dynamically created add-in may be a separate component without its own signature. If Excel requires application add-ins to be signed by a trusted publisher, the XLL’s signature may not satisfy that requirement.
Where can I check Excel’s add-in signing requirement?
Open File > Options > Trust Center > Trust Center Settings > Add-ins and look for “Require Application Add-ins to be signed by Trusted Publisher.” Your organization may control this setting.
Does a trusted location automatically trust a generated COM add-in?
No. A trusted location for the XLL does not automatically give a separate generated add-in a digital signature or satisfy the trusted-publisher requirement.
What if the generated add-in has no visible file location?
Ask the developer how the add-in is created and registered, and which component Excel checks. The developer can determine whether signing is applicable and how to meet the organization’s security requirements.




