Results 1 to 6 of 6

Thread: Set pivot filters to match another pivot table

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Mentor
    Joined
    Aug 2012
    Posts
    375
    Location

    Set pivot filters to match another pivot table

    Hi,

    I have several pivot tables set to different pivotcaches that I wish to control from a single timeline slicer.

    I am able to program the filter settings using
    .PivotFields("Date").PivotFilters.Add2 Type:=xlDateBetween, Value1:=startDate, Value2:=endDate
    I now need to read the filter state of the primary pivot, get startDate and endDate, and apply this to the subordinate pivots - but can not deduce the correct object properties to call/read.
    (this is currently triggered by a pivottable change event - am attempting to read values from "Target")

    Can anyone assist?
    Thanks
    Werafa
    Last edited by werafa; 08-24-2025 at 04:10 AM.
    Remember: it is the second mouse that gets the cheese.....

Posting Permissions

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