Troubleshooting
Problem
When trying to either 'Slice to Excel' or 'Snapshot to Excel' or 'Export to PDF' on particular Excel websheets, this message is displayed on TM1 Web client side : Excel could not open the Xml spreadsheet: Exception from HRESULT: 0x800A03EC And the following message appears in TM1ExcelService.log (in /TM1/bin directory) ERROR Applix.TM1.ExcelApp.ExcelApplication - Exception occurred while building worker book System.Runtime.InteropServices.COMException (0x800A03EC): Exception from HRESULT: 0x800A03EC at Microsoft.Office.Interop.Excel._Worksheet.Copy(Object Before, Object After) at Applix.TM1.ExcelApp.ExcelApplication.GridMergeSheetLoop(XmlNodeList nl, Workbook xml_WB) This document covers only the case when, below "Choose dimension titles to export" from the Websheet Export window, at least one checkbox is selected. If a similar message occurs even if no checkbox is selected, then this is another problem (please contact Customer Support)
Cause
in the VBA project editor, in the properties of one of the sheets, the option "Visible" has been set to "xlSheetVeryHidden".
Currently, only the option "xlSheetHidden" is supported by TM1Web.
Resolving The Problem
- Open the XLS or XLSX file in Excel
- Right-click any sheet tab and select "View code" : the Visual Basic for Applications (VBA) project editor opens.
- In the Project pane, select, one by one, each of the sheets from the current VBA Project, and go to the Properties pane to verify that Visible property is correctly set.
- Here, replace each occurrence of xlSheetVeryHidden by xlSheetHidden.
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21616646