Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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? |