Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

WAD export to Excel - how to change settings?

Hello guys,

I am confronted with some issues in WAD when it comes to do an export to Excel. In a WAD query I have embedded several BEX queries (Grid Item). The display on the screen is fine when I am running the WAD query. But when I choose to export it, the data (Grid elements) gets scrambled and the Excel report is not readable.

1/ How can I choose in which Excel cells the data in the WAD Grid Items will go to? For example, to force the WAD display on the screen to be respected in Excel.

2/ How can the solution for 1/ can be implemented in the global template, to all queries?

Looking forward to hearing your ideas.



Not what you were looking for? View more on this topic or Ask a question