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.