Good afternoon, Gurus!
Is there a way to clear all filters in a pivot table in excel 2003?
I mean in one click, not by individually checking each drop down autofilter and choosing to show all. The problem is that people filter the pivot table and save it but don't unfilter. Excel 2003 does not even highlight those autofilter drop down buttons a different color so you know which ones are filtered.
UGHHH!!!
Is there a way to clear all filters in a pivot table in excel 2003?
I mean in one click, not by individually checking each drop down autofilter and choosing to show all. The problem is that people filter the pivot table and save it but don't unfilter. Excel 2003 does not even highlight those autofilter drop down buttons a different color so you know which ones are filtered.
UGHHH!!!
