IBM Support

"Cannot run the macro 'cc.CompareDb'. The macro may not..." when launch Excel via the Controller Excel link button (plus "Cannot run the macro 'cc.LockScreen'" error when using 'Reports - Run') triggered by version of Excel (in some environments only)

Troubleshooting


Problem

User launches Controller classic client (CCR.EXE). User clicks 'X' button ("Controller Link").
  • An error appears.

User then tries clicking 'Reports - Run'. User chooses report parameters, and then clicks 'run' button.
  • A slightly different error appears.

Symptom

(1) When click green 'X' button:
image 2187
image 2181
Error Launching menu item "Controller Link"
Cannot run the macro 'cc.CompareDb'. The macro may not be available in this workbook, or all macros may be disabled.

(2) When click green 'X' button:
image 2182
Standard Error
Number: 1004
<…>
Cannot run the macro 'cc.LockScreen'. The macro may not be available in this workbook, or all macros may be disabled.

Document Location

Worldwide


[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Component":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.4.2","Edition":"","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"}}]

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 the link to actual document below to access the full document. You will be asked to log on if you are not already logged in. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

More support for:
IBM Cognos Controller

Software version:
10.4.2

Operating system(s):
Windows

Document number:
1282036

Modified date:
09 May 2025

UID

ibm11282036

Manage My Notification Subscriptions