Slicer not alphabetizing new data in excel 2010?

misha0926

New Member
Joined
Jun 15, 2016
Messages
1
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!
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Forum statistics

Threads
1,223,164
Messages
6,170,444
Members
452,326
Latest member
johnshaji

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top