Troubleshooting Excel with SAP/AMS

[lightweight-accordionsub1 title=”How to change your default excel download settings in SAP” expanded=”true” tag=”h4″]

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

[/lightweight-accordionsub1] [lightweight-accordionsub1 title=”What is the correct Excel download setting when exporting an SAP report into a spreadsheet?” expanded=”true” tag=”h4″]

Reference Guide – Downloading an SAP Report into Excel

[/lightweight-accordionsub1] [lightweight-accordionsub1 title=”SIMULATION: How to Enable your Macro Settings and the Save As Icon in Excel” expanded=”true” tag=”h4″]

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.

[/lightweight-accordionsub1]

---

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:  September 28, 2022