The following has been documented & validated on a ECC5.0 and ECC6.0 systems.
When you want to download a ALV report into excel, you need to select the file format each time you select the function to download. Select List -> Export -> Spreadsheet.
A dialog window pops up where you select the file format. Now, when you select the option: “Always Use Selected Format”, each time you want to download into a spreadsheet, this format will be automatically selected.
Most of the times, this may be okay with you, but what if you want to select a different format? This can be challenging, unless you know how to revert back to the dialog window where you can select the format. Any of the list, Setting or System menus will get you there. Just click the right mouse button and select the Spreadsheet option to delete the pre-defined settings:
Once you have selected the Spreadsheet option, the check mark is removed and you can select the file format you want to use each time you download a report. This procedure only works on output formatted in ALV. If you encounter this issue on custom reports that with regular ABAP list format, just have the users run any ALV formatted report to reset the default file format.
Sometimes you work as super user or as a support person and need to reset the settings for a large number of user. To do so, you can run report SALV_BS_ADMIN_MAINTAIN with SE38 or via a custom transaction.
Select the ‘Delete’ option, client and range of user (or list of users) and execute the report.
Select the users and click the deletion icon/button and the settings of these users will be removed.
The users will now be able to select the desired file format and to set their default file format again.
Note: If you have troubles getting XXL entries from this report, make sure you add the parameter SALV_BS_ADMIN_XXL with value ‘X‘ into your user profile (Transaction SU3) as this will activate the XXL format.
ABAP Lists
If the report in question is in the ABAP format, the procedure shown above will not work for that particular report. The workaround is that you run a report with ALV output (example, MM60 Material List report) and remove the default file format from there. Once you have removed the default format, you can run your original report and select the file format you want to use.
Alternatively, you can also enter &reset_excel into the command line (for ABAP Lists only) to reset the default Excel File Format:
The message “Setting was deleted” will tell you if the command was successful.
Add
Add
Comments