+ Reply to Thread
Results 1 to 7 of 7

I want to synchronize slicers from several pivot tables

  1. #1
    Registered User
    Join Date
    05-01-2015
    Location
    Spain
    MS-Off Ver
    2010
    Posts
    4

    I want to synchronize slicers from several pivot tables

    Dear all,

    I have never done any VBA nor macro but I have a project in which i have at least 6 pivot tables from 3 data basis. The slicers allow me to synchronize data for the pivot tables extracted from the same data source but I would like to have a way to make all these slicers (3 in total) to synchronize with only selecting in one place.
    Is it possible?
    Your help would be really appreciated. I am learning about VBS and macro but my level is a very low starter.
    Thanks in advance for your suggestions/ recommendations/ help.

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: I want to synchronize slicers from several pivot tables

    If it all the same data source

    http://blog.contextures.com/archives...-2010-slicers/
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    05-01-2015
    Location
    Spain
    MS-Off Ver
    2010
    Posts
    4

    Re: I want to synchronize slicers from several pivot tables

    Hi thank you for your reply but I have already done this for all the pivot tables that can be connected together. What I am looking for is how to linked the slicers between different data sources together by chosing in one list several data and have them synchronize in all my workbook.

  4. #4
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: I want to synchronize slicers from several pivot tables

    your original post didn't same different data sources

    it "can" be done however it needed to be controlled

    i setup an example for some other user
    http://www.excelforum.com/excel-prog...ot-tables.html

  5. #5
    Registered User
    Join Date
    05-01-2015
    Location
    Spain
    MS-Off Ver
    2010
    Posts
    4

    Re: I want to synchronize slicers from several pivot tables

    You're right I was not accurate in my post but different dta sources is my issue. I will have a deep look and try and will let you now.
    many thanks for your help.

  6. #6
    Registered User
    Join Date
    05-01-2015
    Location
    Spain
    MS-Off Ver
    2010
    Posts
    4

    Re: I want to synchronize slicers from several pivot tables

    dear humdingaling,

    I think it can work (I am working on it) however, imagine you have several pivot tables, several of them link to each datasource (example 3 datasources), you havem made slicers to make all these pivot tables to update at the same time. The only thing that is left is to make those slicers sinchronize.

    I am not very familiar with VBA programmation text but do you think that this filter datapivot example you sent me could apply on slicers instead of pivot table?
    If yes do I only have to change the name pivot table by slicers in your VBA module?
    The slicers allow you to select several options how to translate in VBA?

    I really appreciate any help you can provide me with.

    Cheers

  7. #7
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: I want to synchronize slicers from several pivot tables

    i havent attempted manipulating slicers in vba but i imagine you could do it

    i think this would be a good starting point
    http://www.contextures.com/excelslicersupdatevba.html

+ 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. Synchronize Slicers with multiple data sources
    By dkjhn in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-22-2015, 02:56 PM
  2. Synchronize two pivot tables with a combo box
    By Atiah in forum Excel General
    Replies: 0
    Last Post: 10-04-2014, 12:38 AM
  3. Synchronize Pivot Tables
    By ashishmac in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-20-2013, 05:09 AM
  4. [SOLVED] Synchronize 2 Pivot Tables with a Combo Box
    By sanchdaniel in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-12-2012, 01:58 PM
  5. Synchronize 2 Pivot Tables with a Combo Box
    By sanchdaniel in forum Excel General
    Replies: 3
    Last Post: 03-26-2012, 12:56 PM

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