Most of my numeric items appear in the drop down filter box in order. . I
know all these are numeric and I even tried to move it down to within the
pivot table report and got same problem. In excel 2007, I cannot figure out
how to ensure the drop down is in alphabetical order. This is a productivity
killer when looking for certain items. Any ideas?