Limits of Pivot Tables?

[ext1jdh]

Hi all,

We've got a spreadsheet of about 61,000 rows and 6 columns wide, one of which is a date. These are legal records that are closed out. The records close out on the last day of the month over a period of about 30 years.

What my customer is trying to do is use a pivot table to get a count of how many records fall on a date. For example, a table that shows 12/31/1986 | 63.

He's running 32 bit Excel 2010 and is locked into that version. He is getting out of memory errors when trying to make the pivot table. I'm thinking he's just hitting the limits of what Excel is capable of handling, as the computer is Win7 x64 with 8gb of available RAM.

Is it possible to process that much data through a pivot table in Excel 2010, or will he need to dump that into a database to get what he's looking for?

Thanks,
JH


EDIT - Solved, the guy had a corrupt spreadsheet that had about 300mb of corrupt data.