Export ALV as xlsx

[Former Member]

Hi,

Is there an option in ECC5 to change the ALV export instead of xls file to xlsx file (Excel 2007 )?

Thanks in advance,

Roey

[Former Member]

I think it the alv will be downloaded in the EXCEL file format of which ever edition you have at ur system

[Former Member]

Hi,

It is supported.You should have MS-Office-2007 installed on your machine to save file in .xlsx format.

[Former Member]

hi,

For that you need to install EXCEL 2007 and you need to some settingz in EXCEL.

Adjust the settings like below:

office button (top-left icon) -> excel options -> Trust center -> Trust center settings -> Macro settings ->

The following options need to be selected.

- Enable all macros

-Trust access to the VBA project object model

Export the list to EXCEL.

Regards

Sandeep Reddy

[Former Member]

Thanks,

I'll check that.

Roey