SAP to Excel Data Download Problem in Office 2007 & SAP 4.7

[Former Member]

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

[Former Member]

hii,

call function gui_download to get the data in excel or text or pdf format.

regards,

akshay ruia

[Former Member]

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.

[MrWhan]

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.

[former_member201275]

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.