Getting Pivot Tables to automatically sort rows in alphabetical order
 

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/

Getting Pivot Tables to automatically sort rows in alphabetical order
 

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)


--
Gary Brown
------------------------------------------------------------------------
Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084
View this thread: http://www.excelforum.com/showthread...hreadid=520617