ALV's standard export to excel not working
I am having a hard time looking for the answer why the export to excel button in my alv is not working. I used 'REUSE_ALV_GRID_DISPLAY' FM for my ALV. Once I click the export to excel button. it changes the display to excel but the records are not shown (excel workbook empty). Can anyone help me regarding my problem? thanks in advance.. your help will be really appreciated. Thank you!
Please change the security of Marco in excel of your OS. Mark the checkbox 'Trust access to visual basic project'.