Pivot Table Page Field Issue (Not sorting)
Hi Barb
Click on the relevant fielddrag to Row areaOptionsSortA-ZOKdrag back
to Page area.
The Sort order will get remembered, and new data will sort alphabetically
within the dropdown list.
--
Regards
Roger Govier
"Barb Reinhardt" wrote in message
...
I have a pivot table that has had more data added to it. The page fields
are no longer sorted (since the addition). I'm using Excel 2007. How
can
this be fixed? If it requires code, just send me in the right direction.
Thanks,
Barb Reinhardt
|