01-24-2011 7:31 AM
Hi,
I am facing SAP output data error when downloading from SAP Data into excel sheet using "Excel View" option on ALV Grid Report, no Data is getting displayed in Excel Sheet.
Thanks & Regards
Rajasekhar
01-24-2011 9:24 AM
hii,
call function gui_download to get the data in excel or text or pdf format.
regards,
akshay ruia
01-24-2011 12:31 PM
Be sure your function to go to Excel is &XXL or search the forum for answers to this question...you may require a correction/adjustment to you PC's MS Office settings.
01-24-2011 12:32 PM
In Excel:
Excel Button
Press Excel Options
Trust Center
Trust Center Settings
Macro Settings
Make sure the checkbox to "Trust Access to VBA Project" is selected.
Next guess would be trying to lower the Macro Security setting.
Also, check out OSS note 696069, it may provide you with some additional leads.
01-24-2011 12:55 PM
Hope this helps:
Failure of Excel view within SAP GUI
Sometimes an SAP screen contains a frame that holds Excel (with the SAP
data). This is 'Excel Inplace'. Notably, it is an option in the ALV grid,
where the user can switch between the Excel view and the standard ALV
grid.
With some newer Windows versions it can happen that the SAP data fails to
appear in the Excel frame. Here is a reminder of the fix.
In Excel:
Tools -> Macro -> Security;
select the u2018Trusted Sourcesu2019 tab;
ensure that the box u2018Trust access to Visual Basic Projectu2019 is checked;
click OK.
Exit Excel.
For some SAP standard reports with an Excel view, Excel security needs to
be relaxed further.
In Excel:
Tools -> Macro -> Security;
select the u2018Security Levelu2019 tab;
ensure that the radiobutton u2018Mediumu2019 is selected;
click OK.
Exit Excel.