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/

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