If you manually created any groups that include the old items, ungroup those
items.
Drag the pivot field out of the pivot table.
On the Pivot toolbar, click the Refresh button
Drag the pivot field back to the pivot table
(copied directly from the link I sent you)

As new items are added to the field they do not automattically get sorted,
but rather they are just appended. By following the above it will clear old
items and resort the field...
--
HTH...

Jim Thomlinson


"Craig Graham" wrote:

Thanks Jim - Yes over time the field list has expanded and there is 300
calculated fields. I have an existing macro that clears out "dud" data items
but I would like to somehow sort or group the fields within the list. Do you
or does anyone else know of a way??

Thanks

"Jim Thomlinson" wrote:

Normally a field list will be in alphabetical order. I assume however that
yours is not? Per chance is it mostly alphabetical with a bunch of items
appended to the end out of order? If so then check out this link...

http://www.contextures.com/xlPivot04.html
--
HTH...

Jim Thomlinson


"Craig Graham" wrote:

I have some very large excel pivot tables that I use regularly. How can I
sort the field list into a fashion that makes sense to me?

I would like to sort the list alphabetically is there a way?


Also in excel 2003 you could browse through this list by pushing the letter
e.g. "r' to browse through all fields starting with "r". does this
functionality still exist in 2007?