Dropdown list in PivotTable has deleted items. How to omit?
 

I deleted rows from my source data for a PivotTable, but when I refreshed the
PivotTable, the dropdown list for that field still contains "ghost" items
that were deleted. How do I get rid of them?

Dropdown list in PivotTable has deleted items. How to omit?
 

There are instructions here for clearing old items from a pivot table:

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

Bonny wrote:
I deleted rows from my source data for a PivotTable, but when I refreshed the
PivotTable, the dropdown list for that field still contains "ghost" items
that were deleted. How do I get rid of them?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html