+ Reply to Thread
Results 1 to 5 of 5

Synchronize Slicers with multiple data sources

  1. #1
    Registered User
    Join Date
    08-26-2013
    Location
    Denmark
    MS-Off Ver
    Excel 2010
    Posts
    1

    Synchronize Slicers with multiple data sources

    Hi there,
    I do have 2 different data sources (Source A & Source B).
    Source A contains 20 slicers, source B contains 13 slicers and both do have 4 slicers in common (Let's say Master-slicer 1, 2, 3 &4).
    Example: From source A with 20 slicers, I do make selections on slicer 7, 13,14 and 18 ==> with impact/filtering of Master-slicer 1, 2, 3 and 4.
    So now I need the Master-slicer from both sources to be in sync.

    Any idea how such a code could look like?

  2. #2
    Registered User
    Join Date
    01-03-2013
    Location
    Hartford CT
    MS-Off Ver
    Excel 2010
    Posts
    20

    Re: Synchronize Slicers with multiple data sources

    you can sync the slicer cashes

    The code only responds to a change in a slicer named Slicer_City, located on Sheet2 and will update Slicer_City2 located anywhere:

    Here is an example code:

    Please Login or Register  to view this content.
    Last edited by martystoked; 10-23-2013 at 07:34 AM.

  3. #3
    Registered User
    Join Date
    11-24-2014
    Location
    US
    MS-Off Ver
    2013
    Posts
    1

    Re: Synchronize Slicers with multiple data sources

    Hi, I tried to used your code by changing the Sheet2 to Sheet7 because that is the sheet I want to run the code, change Slicer_City to Slicer_First Name. But it didn't work. Any advice?

    Thank you.

  4. #4
    Registered User
    Join Date
    01-03-2013
    Location
    Hartford CT
    MS-Off Ver
    Excel 2010
    Posts
    20

    Re: Synchronize Slicers with multiple data sources

    Quote Originally Posted by MatchaBlast View Post
    Hi, I tried to used your code by changing the Sheet2 to Sheet7 because that is the sheet I want to run the code, change Slicer_City to Slicer_First Name. But it didn't work. Any advice?

    Thank you.
    Can you attached you excel file so I can take a look? Did you put the code on the same sheet in which the pivot table lives that you want to trigger this slicer sync up?

  5. #5
    Registered User
    Join Date
    11-13-2014
    Location
    Poland
    MS-Off Ver
    2010
    Posts
    3

    Re: Synchronize Slicers with multiple data sources

    Can you add a sample?

+ 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. [SOLVED] Pivot Slicers from multiple Caches - problem with 2nd Slicer displaying incorrect data
    By matt4003 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-14-2013, 03:06 AM
  2. VBA Pivot Table - Multiple Tables - Multiple Sources of Data
    By ryanmorris in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-08-2012, 03:13 PM
  3. Replies: 0
    Last Post: 12-12-2011, 07:27 PM
  4. VLOOKUP using multiple data sources
    By SalientAnimal in forum Excel General
    Replies: 2
    Last Post: 12-24-2010, 04:26 AM
  5. Merging data from multiple sources
    By Clinton Beare in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 10-11-2006, 08:56 AM

Tags for this Thread

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