expand number of rows from limit of 65,536?

G

Guest

I need to bring in data that exceeds the limit of 65,536 rows. Does anyone
know how to expand this limitation?
 
B

Bob Phillips

You can't, that is the limit. You could either use multiple worksheets, or
another product.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
G

Guest

If you have it, consider MS Access as the repository for your data, then use
Excel's ability to query an external database to pull in subsets of data on
which to do your analysis.
 

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

What is the Excel 2007 rows limit for Excel 2003 macros? 0
increase total rows 2
Number of rows in Excel 2007 worksheets 3
Increase rows in worksheet beyond 65,536 row limit 2
Query of an SQL Database 0
Excel 2007 - million rows 2
Adding more than 65,536 rows in Excel 2007 5
Number of Column Limitations 2

Top