ALV and Excel

[Former Member]

Hi All,

I am displaying few data through the FM REUSE_ALV_GRID_DISPLAY. When I click on the Microsoft Excel (CtrlShiftF7) at the ALV toolbar to view the same data in excel sheet it does open the excel sheet WITHOUT ANY DATA. Please help me how to make the data visible in the excel sheet. I tried with all the previously suggested options in this forum.

Please be informed not to send me any non-SDN and non-SAP url.

For helpful suggestion reward points are awaiting.

Thanks,

-A.Singh

[Former Member]

Hi All,

I am displaying few data through the FM REUSE_ALV_GRID_DISPLAY. When I click on the Microsoft Excel (CtrlShiftF7) at the ALV toolbar to view the same data in excel sheet it does open the excel sheet WITHOUT ANY DATA. Please help me how to make the data visible in the excel sheet. I tried with all the previously suggested options in this forum.

Please be informed not to send me any non-SDN and non-SAP url.

For helpful suggestion reward points are awaiting.

Thanks,

-A.Singh

[Former Member]

HI

Can you send ur code. so that we can test and let u know

Regards

[Former Member]

hi Amarjit,

REUSE_ALV_GRID_DISPLAY function module has a very good option, it is called Excel-In-Place.

It solves every problem with exporting to excel.

Refer to SAP standard note: <b>548409</b>

as data in not getting dispalyed, try this out. The solution is described below and involves making a simple change to the default settings in Excel on each client PC. [The security implication of this change has been discussed with the ISS IT Security Officer. Confirmation was given that he saw no reason why changing this setting in Excel to allow SAP to ‘send it data’ will weaken security.]

microsoft excel menu

1. Go to Tools -> Macro -> Security in Excel

2. Select the ‘Trusted Sources’ tab and ensure that the checkbox titled ‘Trust access to Visual Basic Project’ is ticked.

3. With the feature switched on, the data is passed to Excel.

Regards,

Richa

Message was edited by: Richa Singh

[Former Member]

Hello,

Thanks for the helpful reply.

I am trying to reward points to you but it is giving the following error.

Community Forums Error

Error:

Thread is locked for rewarding.

Thanks,

A.Singh

[Former Member]

Hi Richa,

Excel-in-place ?

Could you please tell me why the data is not showing in the excel sheet. Do I need to put my own code at

sy-ucomm = '&VEXCEL'.

Thanks for your quick response.

-A.Singh

[Former Member]

For setting up a correct Excel-in-place, please refer to SAP standard note: 548409

If the Excel does NOT show any data (and ALV does), that is an Excel problem. Allow Macros in your Excel settings.

Regards

Tamá

[Former Member]

Hi Amar ,

first try with REUSE_ALV_LIST_DISPLAY , if u are getting the data with this FM , then u are missing one TEMPLETS @ ur end .

bcos i am also facing the same issue with GRID , but i am getting the Data in Excel for LIST.

Regards

Prabhu