KNOWLEDGE CENTRE

Troubleshooting Excel with SAP/AMS

How to change your default excel download settings in SAP

Reference Guide – How do you change the default Excel spreadsheet download settings?

What is the correct Excel download setting when exporting an SAP report into a spreadsheet?

Reference Guide – Downloading an SAP Report into Excel

SIMULATION: How to Enable your Macro Settings and the Save As Icon in Excel

Is your report output blank when you download into MS Excel? Some computers that have an older version of MS Excel installed, resulting in AMS reports appearing blank when downloading into Excel.

Resolution: Watch this simulation to enable macro settings and the Save As button.

Learn More:

Reference Guide – SAP Excel Settings
Reference Guide – What is the correct Excel download setting when exporting an SAP report into a spreadsheet?
Documentation & Support – Funds Management Reporting
Documentation & Support – Planning & CO Reporting

Last Updated: January 23, 2024