More than 65,536 lines

C

Chip Pearson

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)
 
G

Greg Glynn

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

Delete rows autofilter range problem 5
Copy text with more than 65,536 lines into Excel 9
How to make the shading look uniform around a double spaced line in MS Word? 0
How to create a bubble chart with more than 2 variables. 0
2007 Compatibility Checker states cells outside of range when saving2003 version 0
Counting Access recordset to import to Excel using ADO 5
Black Lines appearing over table borders 0
How to export more than 65,536 lines from Access to Excel 17

Top