PC Review


Reply
Thread Tools Rate Thread

Clear pivot fields - please help

 
 
MichaelR
Guest
Posts: n/a
 
      17th Jun 2008
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
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Clear all pivot table fields with a Macro Harry Flashman Microsoft Excel Discussion 2 11th Dec 2010 04:54 AM
Problem inserting calculated pivot fields into Pivot Table (2007) wamiller36 Microsoft Excel Misc 1 5th Mar 2010 11:40 PM
Macro on filtering pivot table (pivot fields) => debug markx Microsoft Excel Programming 2 28th May 2008 09:32 AM
A Fix - Pivottable - Added calculated fields and now can't clear pivot Andreww Microsoft Excel Programming 0 1st Jun 2007 04:38 PM
Pivottable - Added calculated fields and now can't clear pivot Andreww Microsoft Excel Programming 0 31st May 2007 05:10 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:36 PM.