IBM Support

"Cannot run the macro 'cc.CompareDb'. The macro may not..." when launch Excel via the Controller Excel link button

Troubleshooting


Problem

User launches the main Controller client (CCR.EXE). User clicks the green 'X' (to launch the Controller link). Excel starts to load. - After a few seconds, error #1 appears. Alternatively, if the user clicks 'Company - Data Entry - Reported Values', error #2 appears.

Symptom

Error #1

Error Details
Cannot run the macro 'cc.CompareDb'. The macro may not be available in this workbook or all macros may be disabled.

Error #2

Source: Microsoft Excel
Description: Cannot run the macro 'cc.CompareDb'. The macro may not be available in this workbook or all macros may be disabled.
at Microsoft.Office.Interop.Excel.ApplicationClass.Run(Object Macro, Object Arg1, Object Arg2, Object Arg3, Object Arg4, Object Arg5, Object Arg6, Object Arg7, Object Arg8, Object Arg9, Object Arg10, Object Arg11, Object Arg12, Object Arg13, Object Arg14, Object Arg15, Object Arg16, Object Arg17, Object Arg18, Object Arg19, Object Arg20, Object Arg21, Object Arg22, Object Arg23, Object Arg24, Object Arg25, Object Arg26, Object Arg27, Object Arg28, Object Arg29, Object Arg30)
at Cognos.Controller.Forms.Common.fFrmFrangoFunc.RunExcelMacro(Application xlApp, Object& macro, Object[] args)
at Cognos.Controller.Forms.Common.fFrmFrangoFunc.InitExcelLink(Object& xlApp, String sText, Int32 excelProcessId)
at Cognos.Controller.ControllerForms12.frmDataEntrySelection.StartExcel(

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

UID

swg21971871

Page Feedback