2538957 - Error "Excel Found unreadable content in '<File name .xlsx>'" happens while opening an Excel file exported from Web Intelligence document

• 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>
  =======================================

• SAP Business Intelligence platform 4.x
• Web Intelligence

back slash, colon, limitation, drill down, Excel, export, webi, special characters, error , KBA , BI-RA-WBI , Web Intelligence , Problem