More than 65,536 lines

  • Thread starter Thread starter Fan924
  • Start date Start date
The number of lines in XL 97-2003 is fixed at 64K. There is no way to
increase this. XL 2007 has 1 million rows.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 
Excel 97. Any way to get more than 65,536 lines on a worksheet?
Click to expand...

Congratulations! You've pushed Excel to it's limit. Yeah, we've all
hit that wall from time to time.

I had one application where I ended up importing my data into ACCESS,
then sorting it and doing some pre-work to get it down to below 65500
lines. I don't know if your data is flexible enough for that.
Otherwise, Excel 2007 is your next call.

1,000,000 rows with 16384 columns! Woohoo!
 
You must log in or register to reply here.

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

Copy text with more than 65,536 lines into Excel 9
Counting Access recordset to import to Excel using ADO 5
Avoid importing 65,536 rows 3
How to detect excess rows in txt or csv files before opening? 4
How to export more than 65,536 lines from Access to Excel 17
Check number of rows? 1
What is the Excel 2007 rows limit for Excel 2003 macros? 0
Identifying duplicate entries 1

Back
Top