Community
Application Development and Automation 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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

EXCEL BUTTON ALV MISSING DATA

Go to solution
Former Member

‎2007 Jan 19 4:40 PM

0 Likes
703

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

1 ACCEPTED SOLUTION
Read only

Go to solution
Former Member

‎2007 Jan 30 1:34 AM

0 Likes
567

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.

2 REPLIES 2
Read only

Go to solution
Former Member

‎2007 Jan 30 1:34 AM

0 Likes
568

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.

Read only

Go to solution
Former Member

‎2007 Jan 30 2:37 AM

0 Likes
567

Chris,

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

It is under Tools > Macro > Security..