What is the maximum number of rows that I can have in a Numbers spreadsheet? I am working in a Pages document, a Numbers spreadsheet in it, and I've gotten to 999 rows which looks like the maximum. Seriously?? Thanks for any information on this!
As far as I can tell there is definitely a hard limit of 999 rows in a table in Pages.
If your table in Numbers has more rows than that then perhaps you could try first inserting two tables into Pages and then pasting part of your Numbers data into the first one and the rest of the Numbers data into the second one.
SG
Each table can have a maximum of 65,535 rows and 255 columns. You can, of course, have multiple tables per sheet, and multiple sheets per document.
Though there are similarities, including the formulas you can use, a Pages table and a Numbers table are not the same thing. You cannot have a "Numbers spreadsheet" in a Pages document.
A Pages table can have up to 999 rows.
A Numbers table can have many more rows, though performance often becomes sluggish once you have several thousand rows.
SG
Yes, I’m thinking the problem is that when I brought the Numbers file into the Pages file, the parameters changed. I’ll have to play with it, going back to Numbers, increasing it, then going back to Pages to see what happens. If I’m really limited to 999, then that’s a bummer. This is for a handbook, and the Numbers file is for the member contact information which won’t get too much longer beyond 999, but still a hassle that I may have to work around. Thank you.
Numbers can have:
255 columns and
65536 rows
No, I've gotten to 999 rows and cannot add any more. Is it possible that the number of rows is different when editing a Numbers spreadsheet that has been imported into a Pages file?
That seems likely. Pages is not a spreadsheet app. It’s designed more for creating text documents. You would never find a 65,535 row spreadsheet in a book.
I answered the question regarding Numbers. I have not tried to make the largest table in Pages.
In Numbers for macOS, I entered 70000 for both rows and columns in the "Table Formatter":
number of rows in Numbers spreadsheet
