Thread: Pivot Item: removing non-existant item from the drop down
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_5_] Jim Thomlinson[_5_] is offline
external usenet poster
  
Posts: 486
Default Pivot Item: removing non-existant item from the drop down
Give this a look...

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

Jim Thomlinson


"CinqueTerra" wrote:

My Pivot Table data set has changed. On refresh, the new pivot items are
added to the drop down box; the ones which no longer exist are not removed.
Is there a way to refresh the list to show only items that currently exist?

Thanks in advance!
Reply With QuoteReply With Quote