Share via

Pivot Data changes, refreshed pivot table filter name doesn't change

Anonymous
2018-07-27T18:50:01+00:00

I've updated the name of one of my categories in my original data set.  I refreshed my pivot table and the new name shows up, but it still shows up in the filter list of the pivot table (along with the new name).  Can someone help me to get the name that no longer exists in my data off of my pivot filter list?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Vijay A. Verma 104.9K Reputation points Volunteer Moderator
2018-07-27T19:02:56+00:00

Right click on Pivot > Pivot table options > Under Data tab, set red zone to none

Was this answer helpful?

4 people found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-07-27T20:05:50+00:00

    Thanks so much!

    Was this answer helpful?

    0 comments