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"}}]

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.

Document Information

Modified date:
09 May 2025

UID

ibm11282036