Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

alv template sap_om.xls : List empty

Former Member
0 Kudos

·        Hello,

       I developped a transaction to display a list ALV with the function module 'REUSE_ALV_GRID_DISPLAY' and i want to display the list in Excel :

I select Change Layout -> View Tab -> Prefered View -> Select Microsoft excel and Make sap_om.xls as default but sometimes the list is empty.

I check my options on Excel :

Menu -> Tools -> Options -> Security Tab -> Macro Security ->Set Medium and in Trusted publisher tab select the checkbox Trust Access to Visual Basic Project is press ==> Ok.

But my spreadsheet is empty ( when i display on ALV i have records).

Have you got an idea ?

Thanks for your help..

I

2 REPLIES 2

Former Member
0 Kudos

Did you enable all Macro's as well?

Adjust the following settings of MS Excel 2007:

-----------------------------------------------

Office button (Top-left icon) -> Excel options -> Trust center ->

Trust center settings -> Macro settings

The following options needs to be selected:

- Enable all macros

- Trust access to the VBA project object model

From Note 1094693

Thanks,

Shambu

0 Kudos

The following settings of MS Excel 2003 are selected "Enable all macros" and "Trust access to the VBA project object model".

On Excel 2003 can i have an other problem with ALV  ?

i can't access now to the website SAPnote to see the note 1094693 : I can see tommorow this note.

Thanks for your help.