+ Reply to Thread
Results 1 to 4 of 4

Excel slicer remove unwanted item

  1. #1
    Registered User
    Join Date
    10-04-2012
    Location
    Australia
    MS-Off Ver
    Excel 2016
    Posts
    43

    Excel slicer remove unwanted item

    Hi
    In Slicer, I have some unwanted items but they are not blank or no value.
    Can I remove them from my slicer list?

    thx

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    2013 / 2016 / 365
    Posts
    7,124

    Re: Excel slicer remove unwanted item

    If the slicer is connected to a pivot table, it may reflect pivot table values that used to exist, but are no longer there. The following piece of code removes these old items and refreshes the pivot table. Actually it does it for all pivot tables in the workbook. You can adjust the code as needed.
    Please Login or Register  to view this content.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Registered User
    Join Date
    10-04-2012
    Location
    Australia
    MS-Off Ver
    Excel 2016
    Posts
    43

    Re: Excel slicer remove unwanted item

    Thanks

    But they are not old items.

    For example the slicer has Gross revenue, Licensee Revenue, other revenue and total revenue.

    Now the slicer has all 4 revenue. But I do not to include "total revenue".

    Is it possible?

  4. #4
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    2013 / 2016 / 365
    Posts
    7,124

    Re: Excel slicer remove unwanted item

    Well, that's about as far as I think we can take it without a sample workbook.

+ 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. Excel how to remove slicer blank???
    By Crizlee in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-18-2015, 12:12 PM
  2. Remove spaces and unwanted details from excel sheet
    By CC_deallist in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-08-2015, 12:07 PM
  3. Selecting a Slicer Item in VBA
    By ManUBlueJay in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-10-2014, 08:21 AM
  4. How to auto select from a Slicer last or top item
    By xtrenge in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-07-2014, 06:22 PM
  5. [SOLVED] Remove unwanted rows in Excel 2010
    By kisboros in forum Excel General
    Replies: 11
    Last Post: 04-06-2013, 12:41 PM
  6. quick way to remove unwanted style in excel 2003
    By lelo in forum Excel General
    Replies: 5
    Last Post: 11-23-2011, 02:03 AM
  7. Replies: 1
    Last Post: 01-31-2006, 11:40 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