Home

Pivot Table Drop Down List - New Rows stay at bottom of list even after sorting

davemcd1986
Occasional Visitor

First of all, let me start by saying that I am not very good with Pivot Tables. But, I have a workbook that was created before my time that we use daily so I need it to work correctly. There is a pivot table on Sheet 1 that is pulling source data from Sheet 4. There are 5 columns of data being selected based on a drop down list from the first column titled "Customer". The list of customers in the sheet is sorted A to Z. The problem is that in the drop down list of the pivot table, any new customers that are added to the source data are showing up in the drop down list at the bottom of the list and not in alphabetical order. I have tried sorting the data, refreshing the list, choosing the pivot table options and sorting A to Z (i think this refers to the sorting of the fields, not the data under the field heading title). I feel like this is something simple, but have searched the internet and have not been able to find an answer. Thanks in advance!

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies