Try this:
http://www.contextures.com/xlPivot04.html
Don
"whornak" <whornak[ at ]discussions.microsoft.com> wrote in message
news:20341236-B116-4235-93F7-C4EBD4700947[ at ]microsoft.com...
[Quoted Text] > It seems that as I remove/add data to the source of the pivot table the
> filters remember all previous values in addition to adding newly found
> values. Even when I refresh the pivottable the invalid values still
> remain.
>
> Is there a way to remove those values that aren't available in the data
> source?
|