John Wilson said:
Eric,
Certainly!!!
You can add another 1,536 rows.
The answer to your question is no.
There's a max of 65536 rows and 256 columns in a worksheet.
There's no way to exceed that limit.
Split your data into multiple worksheets or use a database.
Sorry,
John
This limit (2^16) is a long standing limitation of Excel. Rumour is
that very old parts of Excel are involved and changing it would harm
stability and backward compatability. Also evidence in many people's
eyes for what happens when competition is replaced with monopoly, but
anyway ... see this for more
http://groups.google.com/[email protected]&rnum=1
What you can do
a) use Access possibly depending on what you are doing in the
spreadsheet. If such a large spreadsheet is because you are using
Excel as a DB, why not move to a database.
b) try competing spreadsheets. Gnumeric is scalable to large sheets
but I don't think it runs on Windows. OpenOffice won't help, it only
goes to 32K rows to my knowledge
c) Microsoft Office Components has a spreadsheet component. This is a
lot like Excel, although it is also scalable to huge spreadsheets. You
will need to use some visual basic to access the component. In my
experience, (a) is the way to go.
