Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I refresh a PivotTable and remove outdated page field entr.
After refreshing a pivot table in Excel 2000, page fields values include
those that were in the old pivot table data but are absent from the refreshed data. For instance, a page field button named 'Year' lists 1998, 1999, 2000, 2001, 2002 and 2003 as values. However, the data no loger includes any rows for years 1998 and 1999. How do I remove these values without re-creating the pivot table from scratch? |
#2
|
|||
|
|||
There are instructions here for clearing old items from a PivotTable
dropdown list: http://www.contextures.com/xlPivot04.html NT wrote: After refreshing a pivot table in Excel 2000, page fields values include those that were in the old pivot table data but are absent from the refreshed data. For instance, a page field button named 'Year' lists 1998, 1999, 2000, 2001, 2002 and 2003 as values. However, the data no loger includes any rows for years 1998 and 1999. How do I remove these values without re-creating the pivot table from scratch? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
The instructions worked perfectly. Thanks for the help!
"Debra Dalgleish" wrote: There are instructions here for clearing old items from a PivotTable dropdown list: http://www.contextures.com/xlPivot04.html NT wrote: After refreshing a pivot table in Excel 2000, page fields values include those that were in the old pivot table data but are absent from the refreshed data. For instance, a page field button named 'Year' lists 1998, 1999, 2000, 2001, 2002 and 2003 as values. However, the data no loger includes any rows for years 1998 and 1999. How do I remove these values without re-creating the pivot table from scratch? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|