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