KB439109: Refreshing an Excel sheet containing a report converted to a table produces the error “Failed to add XML to grid.” in MicroStrategy Office 10.x

SYMPTOM:
Strategy Office offers users the ability to execute reports and documents directly in Microsoft Excel. After executing a report in Excel, users can then convert the report to a table in Excel using the Quick Analysis tool. However, after converting the report to a table, an error is returned when trying to refresh the sheet in Excel containing the table.

Failed to add XML to grid.
Exception from HRESULT: 0x800A03EC

1. In Microsoft Excel, connect to Strategy Tutorial with Strategy Office.
2. Execute a report.
3. Highlight the report results in Excel (including the headers).
4. Click the Quick Analysis box that appears in the bottom right corner of the highlighted area.

​

1. Click Tables > Tables.

​

1. Refresh the Excel sheet.
2. Notice the error.

CAUSE:
This is an identified defect in Strategy Office 10.x.
ACTION:
This issue has been addressed in Strategy 10.4.6 and 10.10. Upgrade to this version to take advantage of this fix. KB439109