How do I refresh a PivotTable and remove outdated page field entr.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table help - select pages 1
How I refresh pivot table report? 2
how do i refresh a pivot table report in a shared file 1
How do I remove old labels from refreshed pivot tables? 3
Print tab for each page field in PivotTable 1
Pivot Table: Remove old field cell value 1
slow document / pivot table refresh and pivot function 2
Pivot Table - Multiple Page Fields - AND/OR Logic Choice? 1

Back
Top