How to change default selected format for spreadsheet export.

[Former Member]

Hello Experts ,

While downloading one report in excel (spreadsheet export ) , I selected one format & also I selected the option " Always use selected format "

Now I want to change that format , but it doesnot take me to the change format screen since I selected the option of always use this format .

How to deactivate this ? I want to select another format .

Thanks in advance.

Abhishek.

[pnagar]

Hi, One of my User also faced the same issue. They were facing the same in t-codes related to Finance in FBl1n,fbl3n & fbl5n. This is what i did and was able to resolve the issue. I tried T-code fbl3n as below and generated the list as below.

then i went to setting and switch the list to grid as below.

Now after it the output changed to Grid list as below.

Now you could do export directly to Excel as below.

Always remember this problem arises when you select tick mark on below option.

To understand more kindly read about Grid and classic layout in sap.

[yaqoobalvi]

On SAP Netweaver 730 It worked for me.