06-04-2012 3:56 PM
· 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
06-04-2012 4:27 PM
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
06-04-2012 4:40 PM
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.