Is there a maximum number of rows in a sheet?

Paul,

There is no competition between Numbers and Excel in this category. The Numbers limit is a max row number of 65536. You'll never get close to that though. Your hair will gray waiting for calculations to complete before your sheet gets that large. If you need a million rows use Excel or one of the clones. Numbers is not a clone of Excel.

Jerry

It is certainly not any where nearly a million - I think I read around 25000 - search in the forums and you will find the answer. Why any one would want a spread sheet with a million rows I have no idea. Surely a database is a better solution in those instances?

65536??? WHY???

Great. For anyone like me who needs around 100,000 rows, can anyone suggest a way to make a VLOOKUP search 2 different sheets? Or a formula to the same effect?

Don't make me use Excel. Please.

http://en.wikipedia.org/wiki/Listof_spreadsheetsoftware#Specifications

JROA wrote:
65536??? WHY???

Because it's 16^4, which is an integer which may be coded with four bytes.
The step beyond would be 16^6 or 16^8.

But, given the slowness of Numbers, I am unable to work with tables of 10000 rows.
From my point of view, it would be foolish to build tables with 65536 rows with the current app.

Yvan KOENIG (VALLAURIS, France) jeudi 24 décembre 2009 23:55:34

Thanks for the advice, I'm going over to excel now. I knew this day would come.

Good bye and good luck.

Yvan KOENIG (VALLAURIS, France) mercredi 30 décembre 2009 13:41:33