We find that after a pivot table is created, the the drop-down list values of
filter in the table will not be refreshed as soon as the change of data.

E.g, orginally in the pivot table there is a value A in the column,
afterward in the data source value A is replaced by value B. But we can find
that value A is still in the list of drop-down values.

Is this a bug of Excel or there is some configuration of this? Is there any
fix?