News for hackers. Stuff that matters.
Re:Protip for salary seekers: H1-B filings are public by nutjob123 on Thursday April 14, 2011 @12:01AM (#2445536)
I haven't opened the file but this sounds strange. I've reached the excel cell number limit before crashing computers with much less than 8gb of ram. http://office.microsoft.com/en-us/excel-help/excel-specifica...
Re:Protip for salary seekers: H1-B filings are public by smokinn on Thursday April 14, 2011 @12:52AM (#2445674)
Creating a pivot table is very different from simply opening an excel file. Conceptually (it may be more optimized internally) it tries to create a cube of all possible results with all others. (An OLAP cube.)

So if you have columns 1, 2, 3, 4 and rows 1, 2, 3 it will create a cube for a combination of all dimensions.. So for all rows you will have all columns instantly queryable but also 1-2, 1-3, 1-4, 2-3, 2-4, 3-4, 1-2-3, 1-2-4, 1-3-4, 2-3,4, 1-2-3-4 so that you can query any combination of rows/cells and instantly get your result.

As you can imagine this cube gets exponentially bigger as you add dimensions (columns) and will quickly kill excel if you load in too much stuff.