Agile Central - Excel: Plugin throwing error

Document ID : KB000113565
Last Modified Date : 11/09/2018
Show Technical Document Details
Issue:
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)).
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.