search cancel

Agile Central - Excel: Plugin throwing error

book

Article ID: 113565

calendar_today

Updated On:

Products

CA Agile Central On Premise (Rally) CA Agile Central SaaS (Rally)

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)).

Environment

Release: AGCIBM99000-1-Agile Central-IBM CLEARQUEST INTEGRATION-SAAS
Component:

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.