Skip to Content
0
May 13, 2022 at 11:43 AM

Spreadsheet "Excel (In Existing XXL Format)" does not work (XLS)

2335 Views Last edit May 16, 2022 at 09:20 AM 4 rev

Hi all,

I am having some issues when exporting from SAP to Excel on a specific machine.

When I am in a report generating transaction such as FBL3N I try to generate an excel spreadsheet via List -> Export -> Spreadsheet...

image.png

Then the format selection popup appears but when I select "Excel (In Existing XXL Format)" it does not do anything.

image.png

I can only see a message in the bar that says: "Setting was applied", but nothing else happens

image.png

The other formats (XLSX, MHTML and XML) work but I need to export this to XLS using "Excel (In Existing XXL Format)"

This was working fine until a few days ago but suddenly it stopped working.

The popups that should appear and no longer appear are:

image.png

image.png

image.png

I have tried with several users and they all fail on this computer, but they work correctly on other machines, so it must be something related to the Excel or SAP configuration.

I have problems with more transactions where Excel is involved, for example on PC00_M11_DTO I cannot upload the files.

I have tried the following:

- Excel macros and Trusted configuration reviewed

- Spreadsheet export settings reset using the program SALV_BS_ADMIN_MAINTAIN and the transaction code &RESET_EXCEL

- SAP Front End Client has been reinstalled

The Excel version is: Microsoft 365

Any idea how to fix this?

Thanks in advance.

Maria

Attachments

image.png (107.9 kB)
image.png (53.9 kB)
image.png (113.8 kB)
image.png (46.9 kB)
image.png (17.2 kB)
image.png (20.3 kB)