Skip to Content
Author's profile photo Ravi Sankar Venna

How to bring back different download options from SAP to Excel?

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.
File 1.png
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.
File 2.png
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 enter the program name “SALV_BS_ADMIN_MAINTAIN”
File 3.png

Click on “Execute” button

File 4.png
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.
File 5.png
You will get an information box as shown above, click on “OK” (Green Tick Mark)

Please select the entry and click on “delete” button.
File 6.png
You will get the following pop-up box, please click on “Y” for “yes”
File 7.png

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.

File 8.png

Assigned Tags

      33 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Very Nice and new for me to know this. thank You for sharing this.

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks David Feng

      Author's profile photo John Graver
      John Graver

      There is a bit easier way, available also to users that don't have the authorization for SA38:

      1. Rightclick to any part of a report area and from the context menu choose "Spreadsheet".
      2. The standard "Select spreadsheet" dialog appears as shown on pic. #2 in the article. Here you can select desired document type and uncheck the option "Always use selected format".
      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks John for your additional inputs.

      Kind Regards,

      Ravi

      Author's profile photo Former Member
      Former Member

      Dear Mr. John,

                Thnx a ton 4 ur fabulous way of bringing back different download options .

      Best Regards,

      Satendra Singh Sikarwar

      Author's profile photo Former Member
      Former Member

      Jhon,

      This is a very good approach, as no additional user access is required.

      Thanks

      Pankaj B.

      Author's profile photo Ranu Eugene
      Ranu Eugene

      Hi Ravi,

      Nice info. 🙂

      Thanks for sharing and waiting for many more like this. 😉

      Best of Luck. 🙂

      Best Regards

      Eugene.

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thank you Eugene, much appreciated your comments.

      Kind Regards,

      Ravi

      Author's profile photo Eduardo Rezende
      Eduardo Rezende

      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!

      Author's profile photo Former Member
      Former Member

      Hello Ravi,

      Thnx 4 ur sharing.

      Regards,

      Satendra Singh Sikarwar

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Satendra.

      Author's profile photo Srinu S
      Srinu S

      Hi Ravi,

      Very useful information shared. Thanks for sharing.

      Srinu.

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Srinu.

      Author's profile photo Gaurang Gujar
      Gaurang Gujar

      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

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Gaurang for the update.

      Regards,

      Ravi

      Author's profile photo Former Member
      Former Member

      this is the best solution because not all authorize with that t codes

      Author's profile photo CA. Prasad Atmakuri
      CA. Prasad Atmakuri

      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

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      Thanks Prasad your encouraging words.

      I like your sense of humour 🙂

      Best Regards,

      Ravi

      Author's profile photo Former Member
      Former Member

      Excellenttttttt............................................

      Regards

      Zunaid

      Author's profile photo manu m
      manu m

      Great 🙂

      Author's profile photo Former Member
      Former Member

      Thank so much !!!

      Author's profile photo Former Member
      Former Member

      Very useful one...Thanks.

      BR,

      Naresh K.

      Author's profile photo Ravi Grover
      Ravi Grover

      Hi Ravi,

      Wonderful. Thanks for sharing.

      Author's profile photo Former Member
      Former Member

      Thanks Ravi for this Article

      Author's profile photo Former Member
      Former Member

      Nice & useful article Ravi. Thanks a lot for sharing !!!!!

      Author's profile photo Erwin Leitner
      Erwin Leitner

      Hello,

      Super!

      Thank you very much.

      all the best Erwin

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Erwin Leitner
      Erwin Leitner

      Hello,

      Thank you very much.

      all the best Erwin

      Author's profile photo Former Member
      Former Member

      Hello,

       

      Very nice guide !

       

      Thank you

       

      Author's profile photo Ajay Sharma
      Ajay Sharma

      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

      **********

      Author's profile photo Fusion Basis Support Senior
      Fusion Basis Support Senior

      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.

      Author's profile photo Sarah Tatum
      Sarah Tatum

      Thank you so much for this Ravi!

       

      Extremely helpful post 🙂

       

      Best regards

      Author's profile photo Ravi Sankar Venna
      Ravi Sankar Venna
      Blog Post Author

      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