Pivot Table Page Field Issue (Not sorting)
 

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

Pivot Table Page Field Issue (Not sorting)
 

I don't have 2007 but in 2003 just remove the field from your pivot table.
Refresh the table and then put the field back...
--
HTH...

Jim Thomlinson


"Barb Reinhardt" wrote:

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

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