Pivot Item: removing non-existant item from the drop down

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!

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!

Thanks!

"Jim Thomlinson" wrote:

> 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!