KB5 - Why do I get a Row Overflow Error, even if I am under the maximum number
of rows allowed?

Description

If any cells exist on rows beneath your field markers then they will be moved down by the spreadsheet the number of rows that you inserted into your field markers.

Therefore if you inserted 1000 rows into your Excel 97 spreadsheet but had a string in cell A65500 then this string would be moved to cell A66500 and cause a Row Overflow Error. Even if you had nothing in cell A65500 but its background color was yellow, the same thing would happen because in order to preserve formatting for that cell Excel uses a special BLANK internal record.

Excel SpeedGen can insert the maximum number of rows possible under the Excel specifications. Excel has a limit of 16,384 rows for Excel 5.0/95 and 65,536 rows for Excel 97 or above.

Solution

Ensure that there is nothing below your field markers, Select all rows on the spreadsheet below your field markers and right-click and choose "Delete". This will clear everything. Even if you didn't see any data there, Excel might have had invisible placeholder cell records to maintain formatting info. These could potentially be adjust to over the row limit, which is why you are getting an error. But deleting the rows will remove them.

KB5 - Why do I get a Row Overflow Error, even if I am under the maximum number of rows allowed?

Description

Solution

KB5 - Why do I get a Row Overflow Error, even if I am under the maximum number
of rows allowed?