Hello - I am using excel 2010. I have a simple list of names, and have added 2 new names to the existing list. My slicer has updated, but the names are now at the bottom of the list on the pivot table and I can't get it to change. I have gone into the options and made sure it says to alphabetize from A to Z. (If I use custom list it puts their names in the middle of the list regardless of their alphabetical type!). Does anyone have an idea of what I can try to fix the order of the names in the pivot table?
List
Angel (New Name)
Bob (New Name)
Carolyn
Lexi
Mario
Max
Slicer
Angel
Bob
Carolyn
Lexi
Mario
Max
Slicer with custom list checked
Carolyn
Lexi
Angel
Bob
Mario
Max
Pivot Table
Carolyn
Lexi
Mario
Max
Angel
Bob
Thank you!
List
Angel (New Name)
Bob (New Name)
Carolyn
Lexi
Mario
Max
Slicer
Angel
Bob
Carolyn
Lexi
Mario
Max
Slicer with custom list checked
Carolyn
Lexi
Angel
Bob
Mario
Max
Pivot Table
Carolyn
Lexi
Mario
Max
Angel
Bob
Thank you!