Is it possible to fill rows in Excel beyond 65536?

G

Guest

Is there any way that I could populate a single work sheet in MS Excel 2000
or for that matter any of the Excel versions to around 700000 rows.

The maximum size of MS Excel 2000 being 65536(row count). I would like to
bypass this limit and go ahead saving information beyond this limit.
 
H

Harald Staff

Not possible in a single sheet. 2^16 rows is a hardcoded maximum in all
current versions.

You may want to upgrade to Excel 2007 when it arrives.

HTH. Best wishes Harald
 
D

Dave O

You can expand onto other tabs within the same workbook, but as other
posters have noted, 2^16 rows is the current upper threshhold.

Depending on the nature of your data, you may want to consider MS
Access if waiting for the next release of Excel is not a viable
alternative. If you're using a spreadsheet as a database, with 700k
records you may need to consider using a database package.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

#REF! error when copying formula beyond row 65536 in Excel 2007 1
Row limit in Excel 3
how can i increase number of rows beyone 65536 in excel sheet 2
resetting last cell 11
How do I get my Excel 2007 worksheet to go beyond 65536 rows? 1
Importing CSV file with more than 65535 rows to Excel 2007 9
too many columns/rows for excel to hadle 3
Excel should have more than 65536 rows, it should go 150000 3

Top