Microsoft Excel option is not pulling data.

[Former Member]

Hi Friends..

I have created ALV report, When I click the option "Export to Excel" Excel sheet is opened, but no data is there.

if I choose Local file----> Excel..its working fine. But customer required the Export to Excel option.

anybody help me to get the data through Export to Excel option.

Thanks

Gowrishankar

[Former Member]

Data might be more than the XLS file can capture. So please check your report and reduce the data for output as per selection criteria.

Regds,

Anil

[Former Member]

can you tell me the gui status is it the standard one or you had used any custom gui status

and can you also tell what is the ucomm for export to excel ? is it &XXL.

[Former Member]

Hi,

In your PF status pass this parameters:

function Code: &VEXCEL

function Text: Microsoft Excel

icon name: ICON_XLS

info text: Microsoft Excel View

fastpath: M

Thanks,

Krishna

[Former Member]

check your catalog fields matchs with your internal table fields

[Former Member]

Hi Gowrishankar,

Open Excel in your system, go to the menu Tools-> Macro-> Security. Tab Trusted Publishers - make sure that both "Trust all installed add ins and templates" and "trust access to Visual Basic Project" are checked.

Regards,

Sai