pivot table clutter

[mnzy]

I have a workbook that i roll over from week to week by saving as current work week / year. There are at least 10 pivot tables in the work book. What I have noticed is the pivot tables "carry" the previous weeks lookup items even though there may be no data for the item. Is this increasing the file size and is there a way to remove (clean up) the item(s) without deleting the pivot tables and creating new? By the way- over the years the file has grown to 18meg. The file has grown over the years to include more look-ups and support data so the growth may be of no consequence.

 

[Peter_SSs]

I have a workbook that i roll over from week to week by saving as current work week / year. There are at least 10 pivot tables in the work book. What I have noticed is the pivot tables "carry" the previous weeks lookup items even though there may be no data for the item. Is this increasing the file size and is there a way to remove (clean up) the item(s) without deleting the pivot tables and creating new? By the way- over the years the file has grown to 18meg. The file has grown over the years to include more look-ups and support data so the growth may be of no consequence.

Welcome to the MrExcel board!

Is this what you mean?
http://www.contextures.com/xlPivot04.html