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!
 

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
How to detect excess rows in txt or csv files before opening? 4
Avoid importing 65,536 rows 3
How to export more than 65,536 lines from Access to Excel 17
What is the Excel 2007 rows limit for Excel 2003 macros? 0
Check number of rows? 1
increase total rows 2

Back
Top