View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default 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