View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mel Mel is offline
external usenet poster
 
Posts: 74
Default Clearing Multiple Filters?

I have data with numerous col's that can be filtered on. I've also built
graphs to drive off of this filtered data along with a list on the graph
pulling in what data is being filtered on. If I go back to my data tab to
clear all filters (menu bar - data/filters/clear all filters) this will not
update my list that i pulled on my graphs. My question is, is there a macro
out there that i can use to clear my filters? Maybe linking it to a button?