Sub to clear pivot filters

M

MichaelR

Hi,

I'm trying to write a code that will clear all of the pivot filters that I
may have selected while using a pivot chart to view my data. A lot of times
I will select only 2 out of my 10 products for the x axis, 1 out of my 5
geographies as a page filter, 4 of my 12 sales reps and so on. I am trying to
create a macro that is linked to a button on the chart sheet that would clear
all of my filters on all of the fields. Is this possible? Any ideas?

Thanks!
Michael
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top