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.



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