Recorded  macro to change pivot table filter does not work
Results 1 to 2 of 2

Thread: Recorded macro to change pivot table filter does not work
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Mar 2018
    Posts
    59
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Recorded macro to change pivot table filter does not work

    Hi,

    I tried recording myself changing two date filters in a pivot table. The recorded macro does not work and returns 1004:unable to set the currentpage property of the pivotfield class. There are many pivot tables with the same connection and filters in my workbook an my aim is to change their date and date to filters using two cell values, but I'm still ways away from that.
    So, as a starter: How would I go about changing the filters to 2019-02-18T00:00:00 and 2019-02-17T00:00:00?

    Code:
    Sub Macro1()'
    ' Macro1 Macro
    '
    
    
    '
        ActiveSheet.PivotTables("PivotTable11").PivotFields("[Snapshot Date To].[Date].[Date]").ClearAllFilters
        ActiveSheet.PivotTables("PivotTable11").PivotFields("[Snapshot Date To].[Date].[Date]").CurrentPage = "[Snapshot Date To].[Date].&[2019-02-18T00:00:00]"
        ActiveSheet.PivotTables("PivotTable11").PivotFields("[Snapshot Date].[Date].[Date]").ClearAllFilters
        ActiveSheet.PivotTables("PivotTable11").PivotFields("[Snapshot Date].[Date].[Date]").CurrentPage = "[Snapshot Date].[Date].&[2019-02-17T00:00:00]"
    End Sub

  2. #2
    Board Regular
    Join Date
    Mar 2018
    Posts
    59
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Recorded macro to change pivot table filter does not work

    Solved this using slicers connected to all the pivot tables.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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