4

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.

ᔕᖺᘎᕊ
  • 6,173
  • 4
  • 33
  • 45
ejang
  • 173
  • 1
  • 1
  • 6
  • 1
    See http://stackoverflow.com/questions/5119687/fastest-most-flexible-way-to-chart-over-2-million-rows-of-flat-file-data – RedGrittyBrick Sep 04 '11 at 10:25
  • 1
    The really great thing about pondering superuser questions like this is that occasionally it leads you to irrelevant but fascinatingly weird stuff like http://metaphysicaldeveloper.wordpress.com/2011/07/31/hacking-a-gnuplot-into-minecraft/ :-) – RedGrittyBrick Sep 04 '11 at 11:11

2 Answers2

3

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

udo
  • 8,001
  • 7
  • 38
  • 47
0

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.

Erika
  • 606
  • 5
  • 16