View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bonny
 
Posts: n/a
Default 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?