View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MichaelR MichaelR is offline
external usenet poster
 
Posts: 38
Default Clear pivot fields - please help

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