Can you reformat order of items in Pivot Tables after refresh?
 

When I set up pivot tables for time reporting entries at work, there are
often new projects that come in weekly, and every time that I refresh the
report, the new items do not show up in alphabetical order in the drop down
list (in the Page Field). Do any of you know if it's possible to reformat
the order of these items without having to rebuild the report?

I'm dealing with about 200 projects, and it becomes very difficult to sort
when new projects are added at the bottom while the rest are listed
alphabetically.

I'd GREATLY appreciate any ideas! : )

Drag the page field to the row area
Select a cell in the row heading area
On the menu bar, click the A-Z button.
Drag the field button back to the page area

marmur1 wrote:
When I set up pivot tables for time reporting entries at work, there are
often new projects that come in weekly, and every time that I refresh the
report, the new items do not show up in alphabetical order in the drop down
list (in the Page Field). Do any of you know if it's possible to reformat
the order of these items without having to rebuild the report?

I'm dealing with about 200 projects, and it becomes very difficult to sort
when new projects are added at the bottom while the rest are listed
alphabetically.

I'd GREATLY appreciate any ideas! : )


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html