Please refer to my attached sample.
First, the data source column A contain A,B,C,D.
Then, I create a Pivot Table.
Then, I delete the whole row C in data.
Refresh data source. However, the PT filter still have A,B,C,D even though data only contain A,B,D.
First, the data source column A contain A,B,C,D.
Then, I create a Pivot Table.
Then, I delete the whole row C in data.
Refresh data source. However, the PT filter still have A,B,C,D even though data only contain A,B,D.