Excel pivot table refresh sourcing Access DB

[John P]

I have an Access DB that is sourced for various reporting pivots in Excel. The pivots were created with sort logic (i.e. Region, Last Name, First Name). When I add new data to the Access DB table and refresh the pivots in Excel, the data is present, but it is not sorting per the pre-existing rules. The new contacts are added at the bottom of the region and if there are more than 1 new contacts, they are sorted correctly, but not with the others.

For example, the current report looks like:
Region 1 Abie, Mike
Bread, Jack
Yaz, Carl
Ayer, Mike (new addition)
Toad, Joe (new addition)

Any ideas or suggestions to correcting this issue are greatly appreciated. Thanks

 

[Dugantrain]

Yes, this is a pain. You're going to have to write up some code to perform the task of sorting. I don't have that code off the top of my head, but just Record a Macro, Sort the Pivot table, stop Recording, and then place the code that the Macro wrote after the code that you already have which Refreshes the Pivot.