updating pivot table

I have pivot tables that I update weekly with new data. Unfortunately, the
prior week's options are included in the updated drop down lists. The old
data is not included in the calculations so it doesn't affect the report in
that regard but although I only have 18 weeks of data in the source
worksheet, the drop-down lists show the 32 weeks I have been running the
report as options. It is confusing to users of the report.

There's information here on clearing old items in a pivot table:

http://www.contextures.com/xlPivot04.html


Gibran wrote:
> I have pivot tables that I update weekly with new data. Unfortunately, the
> prior week's options are included in the updated drop down lists. The old
> data is not included in the calculations so it doesn't affect the report in
> that regard but although I only have 18 weeks of data in the source
> worksheet, the drop-down lists show the 32 weeks I have been running the
> report as options. It is confusing to users of the report.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html