If ‘Always use selected format’ is checked, then when doing export of ALV List or ALV Grid, it will always be exported with fixed format, no popup for selecting new format.
1) In ALV list, you can enter the function code &RESET_EXCEL in the command field to reset the default setting. This can be done easily by enduser self. For administrator, can execute program SALV_BS_ADMIN_MAINTAIN via SE38 tcode to delete the default entry.
2) In ALV grid, for end user themselves, can reset it as below:
Right click in ALV grid -> Select ‘speadsheet’ context menu -> close the popup of selecting format -> export again now a popup will be displayed for selecting new format. For administrator can execute program SALV_BS_ADMIN_MAINTAIN to delete the default entry.
Here need to pay attention to that from release 7.02, function code &RESET_EXCEL doesn’t work and program SALV_BS_ADMIN_MAINTAIN doesn’t work correctly, so need to apply note 1716802 to resolve function code &RESET_EXCEL issue and note 1590484 to correct SALV_BS_ADMIN_MAINTAIN first.