+ Reply to Thread
Results 1 to 3 of 3

Select (ALL) in a pivot table filter

  1. #1
    Forum Contributor
    Join Date
    05-30-2013
    Location
    France
    MS-Off Ver
    2010
    Posts
    260

    Select (ALL) in a pivot table filter

    Hi,

    I would like to select (ALL) in one of my filters on my pivot table. The filter is in the report filter with several others filters therefore I need to make sure that the select (ALL) applies only to that specific filter.

    I have seen the ClearAllFilters method but I don't think it can apply in this case.

    Thanks !
    Amphinomos
    Last edited by amphinomos; 11-06-2013 at 09:45 AM.

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Select (ALL) in a pivot table filter

    Quote Originally Posted by amphinomos View Post
    I have seen the ClearAllFilters method but I don't think it can apply in this case.
    why not? it's a method of the pivotfield object so it will clear filters from that field only
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Forum Contributor
    Join Date
    05-30-2013
    Location
    France
    MS-Off Ver
    2010
    Posts
    260

    Re: Select (ALL) in a pivot table filter

    Indeed it worked. However when you copy paste over the source data the filter stops working...I'll have to work this out. Thanks for your help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 8
    Last Post: 06-24-2014, 03:35 PM
  2. removing "Select All" and limiting filter choices in a Pivot table
    By jettabar99 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-25-2013, 09:07 AM
  3. Pivot table, assigning a cell wo be change the Pivot table filter
    By jwongsf in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-28-2012, 05:00 PM
  4. Change Pivot table Filter Based on Cell Value *Multiple Filter items* Possible?
    By Flydd in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-27-2012, 06:57 AM
  5. Select and unselect items in a filter in pivot table
    By TPFKAS in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-10-2010, 09:39 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1