I'm working with excel sheet in indesign & it has 10,900 rows of partnumbers.
so when I'm trying to incert new row before & after in indesign it give me above error. i was looking to change the limit of rows in indesign but i don'y know from where i can do this? if you can help me that would be very thankfull
This is a built-in limitation, probably included when the Tables feature was first designed for InDesign 2 (not CS2). Any feature has to have built-in limits, and the engineers probably thought 10,000 rows was reasonable.
You'd have to file a feature request for this to be changed (which I consider very unlikely):
Steve Werner wrote:…
(which I consider very unlikely)
But it would be very, very useful.
It's not uncommon in catalog production that we have to deal with very large tables.
It seems that the place table feature is not affected.
A quick test with InDesign CS5 is showing: one can place tables larger than 10,000 rows. The following screen shot is showing a placed table with 10,100 rows:
You cannot add rows to that table, but you can remove rows.
So it would work, if the OP would add the rows in Excel before placing.
And another limit is the max number of columns in a table: 200
But not for placing. See the following screen shot with a placed table of 256 columns:
However: I tried to place an Excel table with 10,200 rows plus 255 columns and my InDesign CS 5.5 v7.5.3 crashed silently after a few minutes trying to place that thing…