+ Reply to Thread
Results 1 to 1 of 1

Excel 2013 Slicers - slicing multiple data tables at once

  1. #1
    Forum Contributor
    Join Date
    07-25-2012
    Location
    Winterville, NC
    MS-Off Ver
    Excel 2013
    Posts
    141

    Excel 2013 Slicers - slicing multiple data tables at once

    Is it possible for a slicer to work on multiple data tables (tables, not pivot tables) at one time? I have 5 tables each on a separate tab. They heave varying numbers of columns and are all formatted as tables.

    While they have many different columns, they all have some of the same columns (year, month, facility) with the exact same column headers/names. That's what I want the slicers to filter.

    I have a summary page where I want to see a rollup of numerator/denominator and percentage for each table. I want to use the same slicers so when someone sets 'Facility A' they'll see facility A data for all 5 tables. I can do this with data extraction and data validations drop downs....but I was trying to be cool and use data slicers.

    A few important factors:
    *I'm using Excel 2013
    *My file is an xlsm as I have some other macros running
    *When I click on the slicers I have (set up using the first data table), I've tried "report connections" but it's always grayed out
    *my tables are data tables not pivot tables
    *when I tried power pivot, only two of my five data tables were recognized?????? What?!

    Any suggestions? As I work for a medical facility, I can't share the file due to HIPPA and it would be painstaking to recreate. Thank you - Andrea
    Last edited by acroley1; 05-13-2015 at 10:05 AM.

+ 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. Slicers to sync multiple pivots from multiple data sources?
    By cantona_lives in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 06-21-2017, 12:33 PM
  2. Replies: 0
    Last Post: 11-12-2014, 08:39 AM
  3. Excel 2013 : Slicers don't scroll when i scroll the sheet
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-19-2014, 10:23 AM
  4. Pivot Tables -- Slicing and Filtering
    By jetermaw9 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-11-2014, 06:15 PM
  5. Slicing and pivot tables
    By magnus101 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-17-2012, 06:07 PM

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