Unable to export report to excel file from SAP

[Former Member]

  Hi all,

I have a problem to download data from a report. The XL gets downloaded in a different format than my colleague.

We are using the same XL version but two weeks back the SAP GUI 730 got reinstalled to my machine and since then the problem
started.

Can you please confirm is there is any particular user settings for this?

I have login in any different working ( SAP Export ) machine with my login ID and Password and try to export the report to excel file from SAP, and I have same issue . Same we have requested another user to login in my machine with their ID and Password and check the same, They have tried and its working for then in my machine.

see screenshots attached.

Thanks.

[Former Member · Accepted solution]

Hello Maria,

seems you have selected the option as default and hence you are getting that option only

There are three ways to reset the default download option

1) Execute any ALV report on the output screen ,just do a right click ,your default settings will be reset automatically.

Other options along with the below one  to disable defaults set by the user.

2 )Maintain the table SALV_BS_ADMIN using the report SALV_BS_ADMIN_MAINTAIN.

Note 1080608 - Defining ABAP ALV export format for spreadsheet

3) "&RESET_EXCEL" in the command field to reset the parameter in the ALV list -Note  1157927

Anyof the above 3 will work

Regards,

Srini

[Former Member]

Hi all, issue has been solved after execute &RESET_EXCEL in the command field to reset the parameter in the ALV list.

Thanks Srini for your help on this!

[Former Member]

Thanks Maria for the update !

Good to know that issue has been reoslved

Aslo further to this ,from SAP-BASIS 720 onwards  ,SAP has changed the extesnion to .txt  instead of .xls while downloading the excel reports (as .xls leading to other problems)

please  check the notes

975868 : conversions while downloading the excel reports

1683514 : Do not use xls as file extension.

Regards,

Srini

[amarnath_m3]

Hi All,

Did you solve the this issue???

I'm getting this issue now for trying ALV Grid format to XL in t code FBL1N Vendor wise open items.   

Please let me know.. since i'm getting error?

Thanks,

Amar

[amarnath_m3]

Hi Maria,

Did you solve the this issue???

I'm getting this issue now for trying ALV Grid format to XL in t code FBL1N Vendor wise open items.  

Please let me know.. since i'm getting error?

Thanks,

Amar

[Former Member]

I am using SAP GUI 730

I go to List> Export> Spreadsheet, but I get the following message "filter criteria, sorting, totals and subtotals are not taken into account".

So I am not able to salect any format as show the screenhot above.

[former_member210342]

HI maria,

This problem mainly occurs in ALV format.

Open the Excel , Goto Tools>> Macros>> Security.

Set the Security level to Low one

Have you try it on from different ID?

Bcoz Some times it is user specific settings in Layout of report.

Also, discuss with  your technical Team,

[former_member210342]

Hi maria.

are you working on GUI 710

May be your patch level is 0

Download the latest GUI patch and apply it there

or update gui 710 to patch level atleast 4

[Former Member]

Hi all,

Let me explain the issue again.

when I press list -> spreedsheet I would need to see the the option 1 attached in the screeshot below to export the info to Excel (in HTML format)

However when I press there, System Shows:

*Filter criteria, sorting, totals and subtotals are not taken into accountMessage no. 0K064*

and I can just export to a basis excel table.

Any idea?

Thanks!

[former_member183424]

Try once with this format...

Then check excel file....

Then you can also do this file as you want ...

Just in Excel, press Menu-Save as

and select the option

[former_member210342]

HI Dev,

Your doubt is correct it %pc wont work in z report.

But the same can be possible by another way.

HI maria,

In addition to my previous reply.

Just check below image.

click on this

you will get save list in file option.

IT is also available in your incorrect image

select Spread sheet for excel file.

thanks

rahul

[former_member183424]

You incorrect screen shot will show, when you have selected Uncovered

But I assume that can you see the dialog box in GUI 730 ?

Try once with giving %pc in t-code option...(I also can't sure it will work, because its your Z report)

[former_member210342]

hi Maria,

It might be problem of authorization in your ID. Some object may be missing.

If not, then try this..

change the file name extension to .XLS and storage directory to desktop. and ok

try this it will work...

[Former Member]

Execute report>

Right click anywhere in the report output and select Spreadsheet.

A pop up box will appear, select which export option you would like to use and click green check.

NOTE: If you don't see this option then goto Settings>Switch List then try above said.

Thanks,

Kumar