Is there a way to remove items from previous versions of a pivot table for
which there is no longer data? Put another way, can the items that show up
in the pull-down filters be limited just to data currently in the data
source? (For example, I'm creating two versions of a pivot table for two
different clients, but a field called "territory" contains a list of items
for both clients, even if I replace the data set to include just one client.)

Thanks!