Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting a Pivot Table Field List | Excel Discussion (Misc queries) | |||
Sorting Page Area Field Data in Excel 2007 Pivot Table | Excel Discussion (Misc queries) | |||
pivot table field sorting! | Excel Discussion (Misc queries) | |||
Pivot Table - Sorting on Sum field and filterin | Excel Discussion (Misc queries) | |||
Pivot Table Page Field | Excel Discussion (Misc queries) |