Application Development 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: 

Limited Excel inplace

Former Member

‎2010 Apr 15 12:01 PM

0 Kudos
214

Hi guys,

I have an issue related to the Excel inplace fuctionality in SAP, I have an ABAP-developped report which, when run, it returns 20.000 lines. The option Excel in place, in that case, does not work properly, giving me the error "Data set cannot be processed by Excel"

Thank you for a feedback

G

1 REPLY 1

satyajit_mohapatra
Active Contributor

‎2010 Apr 15 12:25 PM

0 Kudos
161

The maximum no of rows that can be displayed in MS excel is 16384 in a single worksheet. You can populate the whole output in different worksheets in the same MS Excel file. OLE can be used for that. Please let me know if you need further information.

Edited by: Satyajit on Apr 15, 2010 4:55 PM