IBM Support

"Unable to cast COM object of type 'System._ComObject' ... No such interface supported" when trying to save an Excel spreadsheet that contains a chart

Troubleshooting


Problem

User creates a Controller Excel link spreadsheet which contains a chart. * User tries to run the spreadsheet (via F9) but receives an error * If the user tries to save it, they receive a similar error. The exact symptoms may vary, but in one real-life case the user sees the message (after running via F9). The user clicks 'Cancel'. The error message reappears. This repeats several times (e.g. three times). Finally, the data appears (seemingly correctly). Afterwards, when the user tries to save the XLS/XLSX file, the same error appears.

Symptom

Standard Error Number: 13
Source: ControllerReports
Description: Unable to cast COM object of type 'System._ComObject' to interface type '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)).

[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.5.1;8.5;8.4;8.3","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSMRTZ","label":"IBM Cognos Controller on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Historical Number

1040647

Document Information

Modified date:
08 May 2025

UID

swg21348030

Page Feedback