Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
updating pivot table to include additional rows | Excel Discussion (Misc queries) | |||
Change Data In Pivot Table | New Users to Excel | |||
Pivot Table not Updating | Excel Worksheet Functions | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) |