topic Re: EXCEL BUTTON ALV MISSING DATA in Application Development and Automation Discussions

EXCEL BUTTON ALV MISSING DATA

Former Member — Fri, 19 Jan 2007 16:40:12 GMT

Hi,

We just upgraded to SAP 6.0 and we are having an issue with some of our zreports using ALV.

When using the excel button on the grid, it starts excel but only the first few lines

the report are now being transferred to excel. Example: If I have five line in my alv report only three will appear in Excel. When you switch back to the SAP viewer

the lines are displayed in the ALV grid.

What I am missing? Any suggestions would greatly be appreciated.

Chris

Re: EXCEL BUTTON ALV MISSING DATA

Former Member — Tue, 30 Jan 2007 01:34:42 GMT

Please implement OSS Note: 947167. Point 5 in the note is the problem you are facing. I had exactly the same problem and after logging the issue to SAP, they replied me asking me to implement this Note and now it works fine- all data on ALV grid are getting transferred to Excel inplace.

Re: EXCEL BUTTON ALV MISSING DATA

Former Member — Tue, 30 Jan 2007 02:37:27 GMT

Chris,

You must change the Excel security setting from High to Medium (or below).

It is under Tools > Macro > Security..