BPS - Max number of row in excel Layout

[Former Member]

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

Francesco

[Former Member]

Check oss note 742647. This is what it says :

<i>Symptom

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

Solution

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]

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.