+ Reply to Thread
Results 1 to 2 of 2

How to connect slicer

  1. #1
    Registered User
    Join Date
    12-22-2015
    Location
    SG
    MS-Off Ver
    2010
    Posts
    40

    How to connect slicer

    I have problem connect the slicer. Department slicer works well but work country and region cannot connect Pivot Table 1 and 2
    Attached Files Attached Files

  2. #2
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    Northumberland, UK
    MS-Off Ver
    various
    Posts
    2,704

    Re: How to connect slicer

    Try following steps:

    1. add offending Slicer fields to both Pivots (temporarily)
    2. right click on newly added field name, check/uncheck "Include New Items in Manual filter" (i.e. opposite of default setting)
    3. click OK
    {should get a dialog at this point that change will be applied to both Pivots etc}

    repeat steps 2 & 3 if you want to revert to the original setting by reinstating original checkbox status (checked/unchecked)

    then, finally
    4. remove the fields added (Step 1) from Pivot
    5. amend connections on both slicers to include 2nd Pivot

    in short, the settings for the field(s) on both Pivots is different -- the above will bring the settings into line such that the slicer can be activated on both Pivots.
    Last edited by XLent; 04-23-2019 at 11:28 AM. Reason: added comment re: optional step(s)

+ 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. Slicer to connect same column in two sources
    By aaallday in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-06-2018, 07:49 PM
  2. Replies: 1
    Last Post: 04-23-2018, 09:43 AM
  3. [SOLVED] Can't Connect Slicer & Timeline To Two Pivot Tables
    By rahul_ferns76 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 07-28-2017, 04:11 AM
  4. [SOLVED] How to connect two different sets of data through a single slicer with 5 common fields?
    By dev.jajati in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 07-29-2016, 03:40 PM
  5. [SOLVED] Connect multiple pivots (with multiple data sources) to one slicer
    By jeroenft in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 08-24-2015, 07:29 PM
  6. [SOLVED] Connect multiple pivots (with multiple data sources) to one slicer
    By jeroenft in forum Excel General
    Replies: 1
    Last Post: 08-24-2015, 04:49 AM
  7. Is It Possible to Connect A Slicer to Two Pivot Tables?
    By NewJerichoMan in forum Excel General
    Replies: 2
    Last Post: 04-26-2015, 01:35 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