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:
==============================
<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><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.
SAP Knowledge Base Article - Preview