ALV Grid output to Excel Spreadsheet

[Former Member]

I have one that is hopefully easy for you guys and when I search on the forum nothing comes up.

Maybe I am searching wrong.

When you have a program that outputs to an ALV grid, there is a button you can output to a file.

Like an excel document. Icon is a document with an x on it.

First time you run it, it will give you the option of excel, star office, or all available formats.

There is also a button at the bottom that says Always Use Selected Format. User

wants to change this, but once the option is gone, you cannot undo it.

How do I basically deactivate the button to not always use the selected format???

Any suggestions would be terrific.

Thanks for your help.

Steve

[Former Member]

Steve,

Try running report SALV_BS_ADMIN_MAINTAIN as indicated in [Note 1080608|https://service.sap.com/sap/support/notes/1080608].

I found this Note with the following search string: "Always Use Selected Format ALV Excel". You may also want to consider doing a search on the report name "SALV_BS_ADMIN_MAINTAIN" for further information.

Also check [Note 1157927|https://service.sap.com/sap/support/notes/1157927] "Export Excel: Reset export parameter from ALV list."

Best Regards,

Jamie

Edited by: James Gaddis on Nov 19, 2008 2:47 PM - Added another Note reference

[Former Member]

Try this

it has all the information about ALV

Regards

Neha

[Former Member]

Thanks everyone for the great responses. OSS Note fixed my issue.

Best Regards,

Steve