Thread: entry not removed in pivot table pull down filter
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
  
Posts: 2,979
Default entry not removed in pivot table pull down filter
There are instructions here for clearing old items from a pivot table:

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


EL in Melb. wrote:
Excel 2003 Edition

An entry removed in the source data remains in the pivot table pull down
filter


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

Reply With QuoteReply With Quote