There is an option that number of list reports (for example S_ALR_87009712) can be downloaded into excel. When we are exporting such reports to excel, you will find a check box called “Always use selected format”. Once you have selected this check box, then this will be saved in the buffer for that user. The user will miss an option to download the report in other available formats. There is no clue how this can be cancelled. Following tip would help you bring back the available option (provided you have sufficient authorisation). Otherwise, you will need to contact the users who have the authorisation to do this for you.
You will have different options how you can download your report into excel file. However, there is a check box called “Always Use Selected Format”. If you have inadvertently selected this check box, from the next time, the report can only be selected with said following excel format that you have selected. Other options are not available in future and the report will be downloaded in default way to this format. Furthermore, the system will not give you any popup to select other options.
In such cases, there is an option to delete the “Always Use Selected Format” entries that are buffered, so that next time when you are downloading, as usual, the system will give you a pop up to select the relevant option. For doing this, you should have access to transaction codes SE38 or SA38
transaction codes (mostly given to the developers only). If you do not have access or unable to get the access, you should request the users / consultants who have access to delete the buffered entries for your user ID.
You need to go to transaction code SA38.
Please select “Delete” if you want to deleted “Change” in order to “Change” the buffer entries. It is preferred to selected “Delete” button, as we are intended to delete the buffer entries already saved. Pleas enter the Client Name and User Name in the “General Data Selection” In “ALV Data” context area, please keep as defaulted.
You will get an information box as shown above, click on “OK” (Green Tick Mark)
Please select the entry and click on “delete” button.
You will get the following pop-up box, please click on “Y” for “yes”
You will get a message as mentioned below:
*Action successfully completed”
Now again when you go back to the report in order to export the line items to excel, you will get your pop-up back in order select the required download excel option.
Very Nice and new for me to know this. thank You for sharing this.
Thanks David Feng
There is a bit easier way, available also to users that don't have the authorization for SA38:
Thanks John for your additional inputs.
Kind Regards,
Ravi
Dear Mr. John,
Thnx a ton 4 ur fabulous way of bringing back different download options .
Best Regards,
Satendra Singh Sikarwar
Jhon,
This is a very good approach, as no additional user access is required.
Thanks
Pankaj B.
Hi Ravi,
Nice info. 🙂
Thanks for sharing and waiting for many more like this. 😉
Best of Luck. 🙂
Best Regards
Eugene.
Thank you Eugene, much appreciated your comments.
Kind Regards,
Ravi
Hi Ravi,I got a different screen for my 702SP12 test system but using the "User-Specific Settings for SAP GUI ALV" I could delete the entry and select a new spreadsheet option.
Thanks for sharing!
Hello Ravi,
Thnx 4 ur sharing.
Regards,
Satendra Singh Sikarwar
Thanks Satendra.
Hi Ravi,
Very useful information shared. Thanks for sharing.
Srinu.
Thanks Srinu.
Hi Ravi,
There is one more simple and tricky way.
Click on Select all--> Right Click->Spread Sheet and UnCheck the option "Always use selected"
Regards,
Gaurang
Thanks Gaurang for the update.
Regards,
Ravi
this is the best solution because not all authorize with that t codes
Thanks Ravi for teaching a new concept ... i guess we don't have to attend any trainings reading your blogs and following SCN would be more than enough 😉
Thanks John Graver for providing alternate way 🙂
Regards
Prasad
Thanks Prasad your encouraging words.
I like your sense of humour 🙂
Best Regards,
Ravi
Excellenttttttt............................................
Regards
Zunaid
Great 🙂
Thank so much !!!
Very useful one...Thanks.
BR,
Naresh K.
Hi Ravi,
Wonderful. Thanks for sharing.
Thanks Ravi for this Article
Nice & useful article Ravi. Thanks a lot for sharing !!!!!
Hello,
Super!
Thank you very much.
all the best Erwin
HI Erwin,
Run any report like FAGLL03-->
In output screen right click on any record-->
Click "Spreadsheet"
In pop up windows, "deselect" "Always Use selected format"
next time you will try to export any data system will show all available options.
BR
Pankaj Bansal
Hello,
Thank you very much.
all the best Erwin
Hello,
Very nice guide !
Thank you
For me:- It was not working then I used below option.
**********
Go in the menu to Settings / Switch list
Click with the right mouse button on the context menu (left site top from the list)
2 Select Spreadsheet
Now you get the old menu back that you can select
**********
Hi Friends,
I have an issue after ECC Unicode that when I go to a report and try to export the content in to excel, it actually displays with embed in the same sap screen.
Regards,
Prabhu Reddy.
Thank you so much for this Ravi!
Extremely helpful post 🙂
Best regards
Thanks Sarah.
Without going to this table level changes,
Please switch any line item report or for that matter any report in ALV Grid, then right click you get the options to remove the check box. Once you remove the check box, next time it will ask you for the format to be saved.
Hope this helps.
Kind Regards,
Ravi