I have a pretty basic pivot table looking at sales data; sales person, customer, products, sales $, volume, margin, unit of measure, etc. Nothing fancy. This data included sales from 2007 through full year 2011, about 3000-4000 lines of data per year. I deleted all 2007 data from the source data, about 3000 lines, and refreshed the pivot table. When I did so, the total file size jumped from about 10M with all data to about 40M after deleting 3000 lines of data and refreshing. I assume this has something to do with the cache, but can't for the life of me figure out how to clean the cache to shrink it. Any direction would be much appreciated.

Paul