I'm dealing with a spreadsheet that has around 500,000 rows and 100 columns in excel 2011. I would like to generate pivot table report for the entire sheet, but it says there is not enough memory. My current computer has 8 GB ram. What kind of memory would I need to allow excel to do those kind of calculations?