Excel addin Query Error:

[Anon Anon]

I log onto Rally, connect Excel to Rally, and point to my selected Workspace & Project. Then I Run Selected Query (a query I have been using successfully for months on various Projects).  A Query Error window pops up with the following message: Unable to cast COM object of type 'System._ComObject' to interface type 'Micorsoft.Office.Interop.Excel.Worksheet'. this operation failed because the QueryInterface call of the COM component for the interface with IID '{000208D8-0000-0000-C000-000000000046}' failed due to the following error: No suuch interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).  

[SeshVeeraraghavan1363555]

Hi Ron,
One of my colleagues faced this EXACT issue, and here's the email from Rally Support on fixing the issue; hope this helps you:

-------------

Thank you for contacting Rally Customer Support regarding the error with the Excel Plugin. 

This error in Microsoft Excel is either caused by a faulty program or inconsistencies in the Windows Registry. 

As the plugin has worked for you before, and is still working for us here, I believe there are inconsistencies in your Windows Registry, that would cause this. To fix this, please try the following: 

- Run the Repair option for MS Office: 
http://www.add-ins.com/how_to_repair_office.htm 
http://office.microsoft.com/en-001/excel-help/repair-office-programs-HA010357402.aspx 

- If that doesn't help, have a look at the following: 
http://stackoverflow.com/questions/12957595/error-accessing-com-components 
---------------
Sesh