Skip to Content
author's profile photo Former Member
Former Member

Download to excel

Hello experts

I need to change export to excel, but I do not know how to change default settings.

e.g. transaction VT11

go to: Shipments / Export / Spreadsheet

Then you can see screen: Select spreadsheet.

In this screen you can choose format and mark checkbox : Always use selected format (if you use this checkbox screen u201CSelect spreadsheetu201D will not appear anymore).

User selected XML but now he needs XLS. How to activate screen u201CSelect spreadsheetu201D to change default settings?

Can anybody help me?

Thank you in advance

Arek

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 13, 2008 at 05:16 AM

    Hi,

    Run Report "SALV_BS_ADMIN_MAINTAIN" from se38 first.

    Click first display radio button on actions and run. It will show all the users name, gui parameter and default format which he had selected.

    Now check the format of the user which you want to change.

    Then go back and click change radio button, in general data select User and in ALV data select ALV_GUI radio button. In excel version select appropriate version that you desired and run report. It will change the default report from XML to excel

    If you want the check box again then delete the user by selecting delete radio button.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 13, 2008 at 04:50 AM

    Hi

    right click on a cell in the data section of your report, for example, on your Network/Activity code. You will get a pop up box u2013 click on u201CSpreadsheetu201D:

    The Select Spreadsheet box will appear. You can then select a format and continue, or just exit the box . The next time you List -> Export -> Spreadsheet, the Select Spreadsheet box will again appear.

    It worked for me. Hope it works for you.

    Regards

    Bhaskar

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 07, 2014 at 12:36 PM

    Hi Experts,

    I am using SAP Version 7.9 in which is clicked option Always used selected format option earlier to export some data from my accounts receivable books, now I am not able to change the format of documents to export it in different format.

    Can any one help me as I dont ahve access to run above T codes for my client SAP.

    I want to change the format back to one which I can select from available options

    Thx

    Satya

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.