SAP Knowledge Base Article - Preview

1767390 - Spend Performance Management: Blank cells in SPM report are overwritten when using the Export to Excel function


These symptoms appear intermittently and are not easy to reproduce - even within the same report.

  • Export to Excel functionality does not work correctly for some reports.
  • If a column in a report does not contain a value, when the report is exported to Excel in Windows 7, the empty cell is shifted to the left.
  • Values are shifted out of the proper column when report is exported to Excel
  • Totals as seen in SPM do not match
  • Values in the measures columns get shifted in .xls when the column position for Fiscal Year is switched



SAP Spend Performance Management (SPM) 2.1 SP7 and SP8.

SAP Spend Performance Management (SPM) 3.0

Windows 7 operating system


SAP BusinessObjects Spend Performance Management 2.1 ; SAP NetWeaver 7.0


Totals as seen in PSM does not matches with excel download; Excel extract; excel extract incorrectly places columns; Erratic behavior of export to xls; SPM Column shift in xls export; PSM; excel; format; formatting; worksheet; , KBA , troubleshooting , EPM-SA , Spend Analytics , 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.