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 |
All times are GMT +1. The time now is 05:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com