View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
wburbage wburbage is offline
external usenet poster
 
Posts: 2
Default How to re-sort a pivot table filter

I maintain a file that includes one data tab and then about 20 pivot tables
running off that data. So when I run a new report I simply replace the data
and refresh the tables. Most of the reports are based on the "project" field
which includes roughly 1,200 different projects and increases on a monthly
basis.

Since there's contantly new projects being added to the data the new project
gets placed on the bottom of the pivot table filter. So if I'm looking for a
particular project the filter itself may or may not be in order. Is there a
way to re-sort the filters within a pivot table filter so this project list
is once again in order?

Thanks,
Bill