Symptom
- An error occurs when opening an Excel file generated from the "Display Actual Costing Result" app via Custom Export.
- Error message: "Excel was able to open the file by repairing or removing unreadable content. Repaired Records: XML error in /xl/worksheets/sheet1.xml part. A semicolon (;) was expected. Line X, column XXXX."
- Error message (variant): "Replaced Part: /xl/worksheets/sheet1.xml part with XML error. Illegal qualified name character."
- After opening the file, the data appears to be corrupted and no content is visible.
Environment
SAP S/4HANA Cloud Public Edition
Cause
The ampersand (&) and less-than (<) characters appear unescaped in xl/worksheets/sheet1.xml, resulting in invalid XML and Excel repair on open.
Resolution
- Rename the downloaded
.xlsxfile to.zip(e.g.,Materials.xlsx→Materials.zip). - Extract the ZIP to a folder.
- Open
xl\worksheets\sheet1.xmlin a text editor (e.g., Notepad++). - Use Find & Replace (Only replace
&and<inside cell data values, not within XML tags.):- Replace
&→& - Replace
<→~<
- Replace
- Save the file.
- Re-compress all contents back into a ZIP, then rename to
.xlsx.
Keywords
custom export, process category view, display actual costing result, excel unreadable content, sheet1.xml, a semicolon was expected, illegal qualified name character, invalid xml, escape characters, ampersand, less-than, material description, xlsx corrupted, actual costing, f6073, &, < , KBA , CO-FIO-ACT-2CL , Actual Costing (Public Cloud) , Problem
Product
SAP S/4HANA Cloud Public Edition all versions
SAP Knowledge Base Article - Public