.
...
By default, the PivotTable will retain all the original values in those filters, even if those values are no longer in the data source. Set ItemToRetain ItemsToRetain to None to make sure the original values are cleared out when the PivotTable is refreshed.
...