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 for Me (Login required).

Search for additional results

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