Pivot Table Not Refreshing Properly?

[Kenneth E. Coakley]

After creating a PivotTable, I discovered that there were several errors in
the underlying data which caused improper values to show up in the
PivotTable field drop-down lists.

I have since re-generated the underlying data and replaced it in the Excel
workbook. However, upon "refreshing" the PivotTable against the new data, I
find that the 'improper values' still show up in the drop-down lists despite
the fact that they no longer exist in the data!

How can I remove the bad values from the drop-down lists without entirely
rebuilding the PivotTable?

Thank you for any help!

Sincerely,
Ken

 

[Debra Dalgleish]

There are instructions here for clearing old items from the dropdown lists:

http://www.contextures.com/xlPivot04.html

 

[Kenneth E. Coakley]

Debra,

Thank you so much for the link! It was exactly what I needed.

Sincerely,
Ken Coakley