SAP Knowledge Base Article - Preview

3635244 - The Complete data from the Purchasing reports cannot be exported to Excel - SAP ERP & SAP S/4 HANA.

Symptom

When attempting to export data from Purchasing reports to Excel, the ALV grid generates a corrupted XLSX file that cannot be opened in Microsoft Excel. The error message displayed is similar to the following:

Removed Part: /xl/sharedStrings.xml part with XML error.  (Strings) Illegal xml character. Line 1, column 230919.
Removed Records: Cell information from /xl/worksheets/sheet1.xml part

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental. 


Read more...

Environment

  • Materials Management (MM)
  • SAP ERP Central Component
  • SAP ERP
  • SAP enhancement package for SAP ERP
  • SAP enhancement package for SAP ERP, version for SAP HANA
  • SAP S/4HANA

Product

SAP ERP all versions ; SAP S/4HANA all versions

Keywords

me2l, ,ME5A, excel export, illegal xml character, purchase order, purchase requisition, data correction, xml limitation, export to excel, ALV, corrupt, XML, illegal character, wrong character, misplaced character, popup, excel error, try to open, not possible, not opening, warning, removed part, /xl/sharedStrings.xml, report, ME2N , PO, ME22N, PR, EINA, EINE, EKPO, line item, Short text, Notepad, Default , KBA , MM-PUR-GF-RE , Reporting , MM-PUR-REQ-GUI , Userinterface - Purchase Requisitions , MM-PUR-PO-GUI , Userinterface - Purchase Orders , 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.