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"
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.