View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default Pivot Table help

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

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

mikeg22 wrote:
I have set up a pivottable that relies on data in another worksheet.
When I put new data in to the data worksheet, the field's old values
stay in the filter dropdown list on the pivottable. I want to know how
to clear these values out so that only values that exist in the data
are available to filter on.


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