+ Reply to Thread
Results 1 to 3 of 3

Is It Possible to Connect A Slicer to Two Pivot Tables?

  1. #1
    Registered User
    Join Date
    02-16-2013
    Location
    Bayside New York
    MS-Off Ver
    Excel 2016 via Office 365
    Posts
    38

    Is It Possible to Connect A Slicer to Two Pivot Tables?

    I strongly suspect there has to be a way. Every time I right click and hit the "Report Connection" button there is only one table listed. How can I get this one slicer work on both of my charts simultaneously?

    First sheet named "Pivot Chart". I need the two separate tables because of formatting within my reports.

    Any help greatly appreciated.

    Attachment 391450

  2. #2
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Is It Possible to Connect A Slicer to Two Pivot Tables?

    http://blog.contextures.com/archives...-2010-slicers/
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    “None of us is as good as all of us” - Ray Kroc
    “Actually, I *am* a rocket scientist.” - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    02-16-2013
    Location
    Bayside New York
    MS-Off Ver
    Excel 2016 via Office 365
    Posts
    38

    Re: Is It Possible to Connect A Slicer to Two Pivot Tables?

    I'm EXCEL 2013 so my ribbons are different than the 2010 description. However, I don't think that's the problem. When I right click "Report Connection" tab on the slicer, I don't get the option of selecting multiple tables. It only lists one table with which to connect.

    The original file may have started out as Excel 2007 file so that might be the problem. But slicers didn't come along until 2010 and I don't think they could slice tables until 2013. So perhaps that is my problem. Just not sure.

+ 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. changing data source for all tables connected with slicer
    By ScottLor in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-14-2017, 08:56 AM
  2. Slicer on Tables
    By cfleming13 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 03-04-2015, 04:59 AM
  3. Replies: 0
    Last Post: 11-12-2014, 08:39 AM
  4. [SOLVED] Link Pivot Tables, Filter with One Slicer
    By Pierce Quality in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 11-23-2013, 11:19 AM
  5. connect tables
    By kwarcek in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-25-2010, 05:44 AM

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