Agile Central - Excel: Plugin throwing error
Article ID: 113565
Updated On:
Products
Rally On-Premise
Rally SaaS
Issue/Introduction
The CA Agile Central (Rally) Add-in for Excel is throwing the following error:
Unable to cast COM object of type 'System._ComObject to interface type 'Microsoft.Office.Interop.Excel.Worksheet.' This operation failed because the QueryInterface call on the COM component for the interface with IID'{000208D8-0000-0000-C000-000000000046}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).
Unable to cast COM object of type 'System._ComObject to interface type 'Microsoft.Office.Interop.Excel.Worksheet.' This operation failed because the QueryInterface call on the COM component for the interface with IID'{000208D8-0000-0000-C000-000000000046}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).
Resolution
This error is indicative of a corrupt Excel Workbook. Leaving the current workbook as-is, open a new workbook and run your query(ies) again. The error should no longer appear in the new workbook. It is recommended that you delete the corrupt workbook as long as you don't need any data from it.
Feedback
Yes
No
Powered by
