Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I understand that Excel can only process 65,536 rows of data. If I'm trying to analyze 7 million rows of data (say, plot a histogram distribution of 7 million values), is there any workaround?

Can I still sort all 7 million values even if only 65K are displayed?

I'm using Excel 2011 for Mac.

share|improve this question
    
1  
The really great thing about pondering superuser questions like this is that occasionally it leads you to irrelevant but fascinatingly weird stuff like metaphysicaldeveloper.wordpress.com/2011/07/31/… :-) –  RedGrittyBrick Sep 4 '11 at 11:11

2 Answers 2

up vote 2 down vote accepted

the following excel restrictions per worksheet apply:

  • excel 2003: can handle 65k rows
  • excel 2007 (and later): can handle 1M rows

to process data which exceeds this row restrictions you have to handle them in multiple worksheets (which can get quite complex, depending on the data you have to analyze...)

note:
sorting this amount of data in excel is no fun... you should consider to process the data in a DB and then use the result(s) in excel (if really needed...)

share|improve this answer
5  
+1 The data has outgrown a spreadsheet and needs a database - perhaps Access with an Excel front end –  Linker3000 Sep 4 '11 at 9:00
1  
It amazes me how many people try to force Excel to be database. –  surfasb Sep 4 '11 at 16:27

If you want stick to the spreadsheet way, there seems to be Resolver One, aiming for a spreadsheet-cum-business-application-IDE based on python. The say the only limit in rows is machine memory.

Offers a 30-day trial, but windows only unfortunately.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.