LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 38
Default Pivot Table Clear All Filters

Is is possible to write a macro that will clear all of the filters in a pivot
table/chart (i.e. the report filter, column labels and row labels filters)
regardless of which pivot fields are being used in the report?

Thanks,
Michael
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hide Pivot Table Filters [email protected] Excel Discussion (Misc queries) 1 March 27th 08 12:15 AM
Pivot Table-using filters or groups Jeff Excel Discussion (Misc queries) 5 January 16th 08 02:50 AM
How to clear pivot table catche Vinod[_2_] Excel Discussion (Misc queries) 1 November 23rd 07 10:01 PM
Pivot table filters MLK Excel Discussion (Misc queries) 1 April 17th 07 07:20 PM
Pivot Table Value and Label Filters Larry Excel Discussion (Misc queries) 0 March 7th 07 03:02 PM


All times are GMT +1. The time now is 02:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"