Product:
Cognos Controller 10.3 (10.3.1.34-0)
Microsoft Windows 2012 R2 server
Microsoft SQL server 2014
Microsoft Excel 2010 or newer

Problem:
When start Excel from inside Cognos Controller client by press on the Excel icon or open data entry, you get a error message.

Error:
Cannot run the macro ‘cc.CompareDb’. The macro may not be available in this workbook or all macros may be disabled.
at Microsoft VisualBasic.CompilerServices.LateBinding.LateGet (Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean [] CopyBack) at Cognos Controller.Forms.Common. fFmFrangoFunc.RunExcelMacro…

Solution:
Start Excel
Go to options in File menu
Go to add-ins
Click on Go at Excel Add-ins
UnMark a Adxloader.Controller.Excellink if it exists.
Click OK.
Exit Excel and Cognos Controller and try again.

Error:
Could not find c:\frangow\frangos.exe /automation. Check the file name is correct spelled and the path is correct…
at microsoft.office.interop.excel.workbooks.open(String filename Object UpdateLinks, object ReadOnly, Object Format, Object Password…
at Cognos.Controller.Forms.Common.fFrmFrangoFunc.InitExcelLink at Cognos.Controller:Forms.ControllerMDI.DoAction…

Solution:
Start Excel
Go to options in File menu
Go to add-ins
Click on Go at Excel Add-ins
UnMark a ControllerXL… line if it exists.
Click OK.
Should only be one line “Cognos Controller Link for Microsoft Excel”
Exit Excel and Cognos Controller and try again.