IBM Support

Error 'The Excel-link is not installed' using Excel 2007 or Excel 2010 caused by option 'Require Application Add-Ins to be signed by Trusted Publisher' being enabled

Troubleshooting


Problem

User clicks on the Excel button in Controller to log into Excel link. User receives error message "The Excel-link is not installed".
However, the Controller Link Add-In appears to have been installed correctly, for example:
1. Controller Excel link entry can (correctly) be seen in Control Panel->Add or Remove programs
2. In Excel 2007/2010, Excel Option -> Add-Ins, Controller add-in is (correctly) shown in Active Application Add-in list
3. In Excel 2007/2010, Excel Option -> Trust Center, click on Trust Center Settings, Macro Settings, both "Enable all macros (not recommended: potentially dangerous code can run)" and "Trust access to the VBA project object model" are (correctly) enabled.

Symptom


The Excel-link is not installed

[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.2.0;10.1.1;10.1;8.5.1;8.5","Edition":"All Editions","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSMRTZ","label":"IBM Cognos Controller on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Historical Number

1042143

Document Information

Modified date:
08 May 2025

UID

swg21362039