SAP Knowledge Base Article - Preview

3395751 - Error happens while opening Excel file (Data-only) 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: "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 opening in Excel
  • In the error log from Excel, see below content:
    ==============================
    <logFileName>error192760_01.xml</logFileName>
    <summary>Errors were detected in file 'file path'</summary>
    <additionalInfo>
    <info>Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.</info>
    </additionalInfo>
    <repairedRecords>
    <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)
  • SAP Business Intelligence platform 4.3 (BI4.3)
  • Web Intelligence (WebI)

Product

SAP BusinessObjects Business Intelligence platform all versions

Keywords

back slash, colon, limitation, drill down, Excel, export, webi, special characters, error, data, XLSX , 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.