Getting Pivot Tables to automatically sort rows in alphabetical order

[Kei]

Hi

Is there a way, whether it be by VBA or on pivot table properties where
I can get pivot tables to automatically sort data in alphabetical order
everytime I press refresh. For some reason, any new people that I add
on my sheet after the table was produced gets tacked at the bottom. IE


Original Data - this is how data looked like when data was produced

Apples Pears Peaches
Bob 2 3 1
Harry 3 2 1
James 1 0 3
Jim 1 4 2

This is what happens when I add new data and press refresh:

Apples Pears Peaches
Bob 2 3 1
Harry 3 2 1
James 1 0 3
Jim 1 4 2
Andy 1 4 2
Barry 2 3 1

Desired result when I press refresh is

Apples Pears Peaches

Andy 1 4 2
Barry 2 3 1
Bob 2 3 1
Harry 3 2 1
James 1 0 3
Jim 1 4 2

Thanks in advance
K/

 

[Gary Brown]

If you right click on the field name heading and select field settings
and click on Advanced, you can select the sort order (Ascending
Descending etc etc)