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.
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
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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!
Discuss This Question: 4  Replies
click on Spreadsheet.
Then you will get options to change the format.
Cheers
Anil