+ Reply to Thread
Results 1 to 6 of 6

Is there any way to tell if a pivot table has slicers?

  1. #1
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Is there any way to tell if a pivot table has slicers?

    Often the slicers are moved off screen, then can even be moved to a different sheet, so it's not readily apparent that they are there. This can be very dangerous. Is there any way for the user to know if there are slicers attached to a pivot table?
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  2. #2
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Re: Is there any way to tell if a pivot table has slicers?

    Good afternoon ChemistB

    From VBA? Try entering this in the immediate window of the VBE :
    Please Login or Register  to view this content.
    There's a really good article here about using slicers with VBA if you're interesting in taking it further (the official MS page on SlicerCashes is, sadly, a little wanting.

    HTH

    DominicB

  3. #3
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Is there any way to tell if a pivot table has slicers?

    Thanks Dominic, I will use this and I will check out that article. So strange that it can only be detected through VBA. At least with a filter, there's the little funnel cluing the user in. or with "protect workbook" there's the "depressed" icon.

  4. #4
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Is there any way to tell if a pivot table has slicers?

    Okay, trying to expand upon this information. I tried this code
    Please Login or Register  to view this content.
    Unfortunately,
    Please Login or Register  to view this content.
    "Object doesn't support this property or method"
    Any thoughts?
    Last edited by ChemistB; 03-07-2016 at 11:52 AM.

  5. #5
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Is there any way to tell if a pivot table has slicers?

    Ahh, found the answer in the article that Dominic pointed me to. This code seems to work
    Please Login or Register  to view this content.
    Still interested if anyone knows a non-VBA clue.

  6. #6
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Is there any way to tell if a pivot table has slicers?

    Okay, I found it. If you select a cell within the pivot table and then go to tab Options. Select the dropdown on "Insert Slicer" and there is "Slicer Connections". That gives you a list of all the slicers in the workbook. Checked slicers are relevant to the current Pivot table, non-checked slicers belong with other slicers.

+ 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. Pivot Table Formatting - Slicers
    By aaaaaron42 in forum Excel General
    Replies: 0
    Last Post: 10-05-2015, 12:59 PM
  2. [SOLVED] Disconnect Slicers, Change Pivot Table Source, Reconnect Slicers: a problem
    By Geoff. in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-30-2015, 02:27 PM
  3. How do I stop slicers resetting row heights in the pivot table?
    By MattAkers in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-18-2014, 09:21 AM
  4. Use combobox value to filter Pivot Table like slicers using VBA
    By limalf in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-17-2013, 07:31 PM
  5. Can you have pivot table fields as slicers?
    By no.18shirt in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-20-2013, 05:12 PM
  6. Can you have pivot table fields as slicers?
    By no.18shirt in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-19-2013, 10:39 AM
  7. Replies: 2
    Last Post: 05-24-2013, 03:58 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