expand number of rows from limit of 65,536?

N

Niner

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

Duke Carey

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

increase total rows 2
Number of rows in Excel 2007 worksheets 3
Infopath file size exceeds the limit allowed and cannot be saved 0
2007 Compatibility Checker states cells outside of range when saving2003 version 0
Cross-sheet dependencies (smart recalc limits) 0
How to populate other fields when a dropdown was changed 13
Compatibility error when saving file. 4
Excel Row Limitation 5

Top