Can the max. number of 65,000 rows in Excel be increased?

G

Guest

http://groups.google.com/advanced_group_search?as_ugroup=*excel

If you do a google search you'll find some macros that people have offered
that will put the first 65k+ rows in the first sheet, the next 65k in the
second sheet, etc

FWIW, you are going to be better served by putting that data in Access or
MSDE and writing queries against it to summarize the data, or using Excel's
Data>Import External Data to pull in just the relevant rows. JMHO.
 

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

How to have more than 65,000 rows in excel 2007 3
Sort more then 65,000 rows in Excel 2
Deleting excess rows from a spreadsheet 1
More than 65,000 days. 1
Excel 2003 to Excel 2007 Compatability 4
need more than 65,000 lines 6
Excel 2003 column number limits 1
Deleting unwanted and empty rows... 2

Top