I have Pivot Table (Excel 2007) that contains a Report Filter of Employee Names and Hours Worked. When I append new data for new employees, how do I sort the entries in the Pivot Table Report Filter to include the new employees in Alphabetical Order. Currently, the new employees are at the bottom of the Filter selection drop down list.
The first time I created the table, they were in Alphabetical Order, no matter how the underlying data was sorted.
The first time I created the table, they were in Alphabetical Order, no matter how the underlying data was sorted.