Solved: Issue in Excel download from ALV output

Former Member · ‎2010 Aug 03

Dear Experts,

I have generated an ALV Output using FM "REUSE_ALV_GRID_DISPLAY". When i try to download the ALV Output in Excel spreadsheet, I am not getting the data in Excel sheet. Kindly help me in this regard.

Thanks in advance,

Regards,

Ramesh Manoharan

craig_scott2 · ‎2010 Aug 03

This problem is often because of the security settings in Excel. In Excel, go to Tools --> Macro --> Security. I think the Security Level should be set to Medium. On the Trusted Publishers tab, set "Trust access to Visual Basic Project" at the bottom. Close Excel and SAP and restart, then try it again.

.. Craig

Former Member · ‎2010 Aug 03

Hi,

you didn't discuss what error you have got when you are trying to down load the alv grid in excel format...

Please be clear...

Regards,

Kiran

Former Member · ‎2010 Aug 03

Dear Kiran,

I am not getting any error. When i try to download the ALV Output in Excel spreadsheet, i am not getting any data in that excel sheet.

Regards,

Ramesh Manoharan

craig_scott2 · ‎2010 Aug 03

This problem is often because of the security settings in Excel. In Excel, go to Tools --> Macro --> Security. I think the Security Level should be set to Medium. On the Trusted Publishers tab, set "Trust access to Visual Basic Project" at the bottom. Close Excel and SAP and restart, then try it again.

.. Craig

Former Member · ‎2010 Aug 04

Dear Craig,

I am using MS Excel 2007. Can you let me know where exactly i need to look into for Tools->Macro->Security.

Regards,

Ramesh Manoharan

craig_scott2 · ‎2010 Aug 04

Sorry, Ramesh. I have Excel 2003 so I can't tell you how to find it. Perhaps you can search for macro security in Excel Help?

.. Craig

craig_scott2 · ‎2010 Aug 04

I understand that the macro security is shown on the Developer tab, which you have to enable to display in Excel 2007. It's under Excel Options --> Popular --> Show Developer tab in the ribbon.

ravi_lanjewar · ‎2010 Aug 04

Hi,

You can check execute authorization of objec S_GUI with your BASIS team.

Former Member · ‎2010 Aug 04

hi ramesh,

Please try below options.

after getting the ALV disply , Go to Menu LIST->Export->Spreadsheet.or microsoft excel view (Cntrl + Shift + F7)

It will give some options to see the data in spread sheet format, hope you can save this to local desktop also.

or

please check the extension, it should be .XLS not .XLSX .some times .XLSX format wont be supported

regards,

pradeep

Edited by: Pradeep Kandgal on Aug 4, 2010 6:54 PM