Pivot Table won't refresh - not enough resources | Excel forum

Hi,

I've built a pivot table off a query table that is refreshed based on a given date range. There are 4 columns in the table. A refresh will bring in around 300k rows per year.

For a date range from 31/12/2006 - 31/12/2009, this returns around 900k lines of data and the pivot table can be refreshed with no issues. This is the case for any date range after around 2005.

The issue arises if I choose a date range pre 2005 - say 31/12/1999 - 31/12/2001. This returns much less data - more like 350k rows so I would expect the pivot table to refresh. It doesn't and instead I get an error saying there isn't enough resource. After some testing it seems the max number of rows that will pivot for this date range is around 200k.

Do you have any ideas as to what could be causing this difference in behavior?

Thanks,

Ed