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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

pivot table - drop down filter box has 10% of items out of order 2
Pivot Table Report Filter Sorting 3
Pivot Table Page Break Refresh Problem 0
Refresh order when refreshing all in a workbook 1
Pivot Table Refresh? 2
Pivot Table field list order 1
Pivot tables - counting unique numbers 2
Refreshing a pivot table 1

Back
Top