Export data from SAP to all Excel Format

5 pts.
Tags:
SAP
SAP Import/Export
I am end user of SAP I want to export data from SAP to Excel. But by mistake, I have selected always export in selected format so now whenever I tried to export data, it will directly export to selected format and not asking me to which format I want to export data. Can any one help me to deselect that option which I have by mistake selected and then I will able to export data in all available format.
Asked: Last updated:
Related Questions
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

Use the option List, Export, Spreadsheet and finally use the XML format. Also, mark the checkbox of always ask the export method. 

Discuss This Question: 6  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • malkhan
    SELECT COLUMN IN SAP DATA LIST >>CLICK RIGHT ON HEADER >>CHOOSE LAST OPTION THAT IS SPREADSHEET CLICK >>MAKE SURE DESELECT ALWAYS USE FORMAT>>OK FINALLY CHECK U WILL GET ALL FORMATS-MALKHAN
    10 pointsBadges:
    report
  • anilkra
    Right click on the record which you are going to export.

    click on Spreadsheet.
    Then you will get options to change the format.

    Cheers
    Anil
    10 pointsBadges:
    report
  • mp868534tam
    I click the spreadsheet but no options & any options. I can't export the data to excel. Any one can help.Thanks
    20 pointsBadges:
    report
  • pavanalapati
    Solution:
    In general once you select "Always use selected format" option , you can't change in FBL3N/5N/1N but workaround is to go to "FS10N" and execute, now on the report right click and choose spreadsheet and remove the default option.
    10 pointsBadges:
    report
  • matlhakud
    I'm not able to export SAP document to Excel.
    10 pointsBadges:
    report
  • Subhendu Sen
    @matlhakud, have you read all of these discussions & answer? For more help, please link here:

    http://kb.mit.edu/confluence/display/istcontrib/Downloading+SAP+Reports+to+Excel

    130,760 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: