Exceeding 64000 rows in excel

  • Thread starter Thread starter EricS
  • Start date Start date
E

EricS

Does anyone know a way to exceed the maximum of 64,000 rows in excel
2002. add-in ? work-around ????
 
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
 
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
Click to expand...

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.


 
Hi Eric!

You can't change the specification but you might work around it.
Here's an old suggestion from Tom Ogilvy:

Quote>>
Go into word or wordpad and break your file in half. (select half of
the rows, then delete, then save the file to a new name. Repeat for
the other
half).

Then import each half separately.
<<End Quote

But you might look more carefully at why you are exceeding the limit
as 65536 starts to get very clunky and there may be better ways or
programs for you.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top