Product:

Cognos Controller 11.0.1200
Microsoft Windows 2019 server

Issue:

Cognos Controller use can not open excel from data entry – the open button is grey, or the when they click on the excel icon, the excel crash with error like this:

Unable to cast COM object of type ‘Microsoft.Office.Interop.Excel.ApplicationClass’ to interface type ‘Microsoft.Office.Interop.Excel._Application’. This operation failed because the QueryInterface call on the COM component for the interface with IID ‘{000208D5-0000-0000-C000-000000000046}’ failed due to the following error: Interface not registered (Exception from HRESULT: 0x80040155).

Solution:

Restart the laptop and reinstall Microsoft Office is the solution.

 

 

More Information:

https://www.ibm.com/support/pages/user-not-automatically-logged-excel-link-when-using-controller-client-excel-based-functionality-example-data-entry-leading-security-error-1-errors 

https://www.ibm.com/support/pages/troubleshooting-user-not-automatically-logged-excel-link-when-launching-functionality-main-controller-program-ccrexe

https://www.ibm.com/support/pages/user-not-automatically-logged-excel-link-when-launching-functionality-main-controller-program-caused-corrupt-xuser-table 

https://www.ibm.com/support/pages/open-button-greyed-out-intermittently-cannot-open-any-data-entry-forms 

https://www.ibm.com/support/pages/troubleshooting-interface-not-registered-exception-hresult-0x80040155-when-trying-use-data-entry-reported-values 

https://www.ibm.com/support/pages/unable-cast-com-object-type-queryinterface-call-com-component-interface-not-registered-0x80040155-error-launching-excel-link-controller-caused-orphan-registry-key