Showing results for 
Search instead for 
Did you mean: 

BPS - Max number of row in excel Layout

Former Member
0 Kudos

Hi guys,

in layout on excel i have to paste about 200-300 rows. I saw that the limits is 20 row. Is it exactly ?

Where is the paramiter to modify this number.

Please help me


Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Check oss note 742647. This is what it says :


You use Excel Web Component as a display tool in the web-based planning. In case of simple lead columns the system always generates - as in the GUI-layout - 20 dummy-rows below the last filled row for the entry of new records as a standard function. In order to change this number of dummy rows there is report UPP_SET_DEFAULT_DUMMIES, which, however, up to now works only for the planning in the GUI. In order to make it also effective for a planning that is based on Excel Web Component, implement this note.

Other terms

Dummies, new rows, Web, Excel Web Component, OWC


Import this note or SP 21 for SEM 3.1B, SP16 for SEM 3.2, or SP 12 for SEM 3.5.</i>

Former Member
0 Kudos

The 20 row restriction was put in place for performance reasons. You can certainly increase the number available, but if it's hurting your performance, you should look at doing a file upload in these situations.