Results 1 to 3 of 3

Thread: Pivot Table Change Event in VBA
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Sep 2011
    Location
    India
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Lightbulb Pivot Table Change Event in VBA

    I have many pivot tables in a workbook, there are multiple "report filters" which are the same on all pivot tables in the workbook. Is there any way in which if a "Report filter" is changed on any one pivot table, the other pivot tables reflect the same filter?

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pivot Table Change Event in VBA

    You can try some of the files that are available here:

    http://www.contextures.com/excelfiles.html#Pivot

    For example, PT0021 or PT0025.
    Regards,

    Juan Pablo González
    http://www.juanpg.com

  3. #3
    Board Regular
    Join Date
    Sep 2011
    Location
    India
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pivot Table Change Event in VBA

    Thank you very much that was exactly what I was looking for....simply beautiful.

Some videos you may like

User Tag List

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
  •