Reset ALV Export Option for User

On any ALV screen when user selects Export->Spreadsheet they usually get a dialog box for selection of format in which output needs to be exported.



As long as user doesn't select 'Always Use selected format', this dialog will be presented every time user select to export. However once the 'Always Use Selected Format' is checked user will never get this dialog box and the selected format will get automatically selected while exporting the ALV List.



Report SALV_BS_ADMIN_MAINTAIN is used to reset this setting. It's easy, run the report, select and delete the record for the specific user from report output and that user will get the dialog again.



This works fine with all other format but ‘Excel (In Existing XXL)’. If user has selected this format and checked ‘Always Use selected format’ you will not see anything in report SALV_BS_ADMIN_MAINTAIN for that user unless parameter id SALV_BS_ADMIN_XXL is set in your profile (not users).