07-01-2009 8:24 AM
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
07-01-2009 11:19 AM
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
07-01-2009 8:40 AM
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
07-01-2009 9:29 AM
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.
07-01-2009 9:34 AM
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
07-01-2009 9:35 AM
07-01-2009 11:19 AM
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