2538957 - Error happens while opening Excel file exported from Web Intelligence document which sheet name contains special character | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2538957 - Error happens while opening Excel file exported from Web Intelligence document which sheet name contains special character

Symptom

  • Error happens while opening Excel file exported from Web Intelligence document which sheet name contains special character
  • Error: "Excel Found unreadable content in '<File name .xlsx>'. Do you want to recover the content of this workbook? If you trust the source of this workbook, click Yes." when using Office 2007
  • Error: "We found a problem with some content in '<File name .xlsx>'. Do you want us to try to recover as much as we can?". If you trust the source of this workbook, click Yes." when using Office 2013
  • Error: "One or more worksheets in this workbook have names that contains square brackets: []. To avoid unexpected results when referencing these worksheets, remove any square brackets from their names." when exporting to XLS format
  • In the error log from Excel, see below content:
    =======================================
    <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
    <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>xxx.xml</logFileName><summary>Errors were detected in file 'C:\Users\<>\Downloads\Test1.xlsx'</summary>
    <repairedRecords summary="Following is a list of repairs:">
    <repairedRecord>Repaired Records: Worksheet properties from /xl/workbook.xml part (Workbook)</repairedRecord>
    </repairedRecords>
    </recoveryLog>
    =======================================

Read more...

Environment

  • SAP Business Intelligence platform 4.1 (BI4.1)
  • SAP Business Intelligence platform 4.2 (BI4.2)
  • Web Intelligence (WebI)

Product

SAP BusinessObjects Business Intelligence platform 4.2

Keywords

back slash, colon, limitation, drill down , KBA , BI-RA-WBI , Web Intelligence , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.