SAP GUI 7.20 export to Excel issue

[Former Member]

A user I am assisting was unable to export a report to excel. The only option was XML file nm. I followed the instructions on this page: http://scn.sap.com/message/10800921

After that we were able to export to Excel, however she has to follow all of the steps each time in order to export as .XLS. The steps are as follows:

1. create a report with the GRID Control

2. click the right mouse button in one row of the grid control

3. choose from the context menu spreadsheet (Excel)

4. choose select all available formats

5. select Excel (in the previous XXL-Format)

6. answer the remaining questions and do a export in Excel

Is there any way to get these to stick? Or another way for her to export the report to Excel?

Thanks,

Ben

[Former Member · Accepted solution]

Hi Ben,

cant you simply set user parameter SALV_BS_ADMIN_XXL to 'X' in SU01? According to note 1125812 this should do it.

Kind regards,

Jann