+ Reply to Thread
Results 1 to 3 of 3

Removing "(Blank)" from pivot table slicers

  1. #1
    Registered User
    Join Date
    02-03-2014
    Location
    Boston, MA
    MS-Off Ver
    Excel 2010
    Posts
    67

    Removing "(Blank)" from pivot table slicers

    I am making a series of pivot tables, and due to large quantity of tables needed, am using a macro to create the pivot tables. When I recorded the macro, I deleted a blank row in hopes that "(blank)" wouldn't show up in the slicers (I did this manually for another table, and it worked). However, "(blank)" is showing up when I use the macro.

    How do I get rid of a field in a pivot table slicer? Specifically all that say "(blank)".

    For example, right now I have slicers that say

    MANAGER NAME
    Name 1
    Name 2
    Name 3
    (blank)


    Thanks

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019
    Posts
    3,865

    Re: Removing "(Blank)" from pivot table slicers

    I generally replace all the Cells with No Data in the Source with something like "-" or something. It is better than getting that annoying (Blank). I dont thinks there is a way to plainly not have that Blank Field on your slicer.

    Just one Question, Why not delete the Rows that contain "Blank" in the source data? I dont think you will be using them if you prefer not to have Blanks in your Slicer anyways?

    Cheers!
    Deep
    Last edited by NeedForExcel; 02-18-2014 at 12:08 AM.
    Cheers!
    Deep Dave

  3. #3
    Registered User
    Join Date
    02-03-2014
    Location
    Boston, MA
    MS-Off Ver
    Excel 2010
    Posts
    67

    Re: Removing "(Blank)" from pivot table slicers

    I am wondering if there is a way to get the "(blank)" to not show up in the slicers WITHOUT modifying the source data?

    The reason I want to do this is twofold:

    1.) I have about a hundred pivot tables to make, and with a deadline it would be best to not have to manually alter all the source data.

    2.) Some of the source data does NOT have any blank rows that I can see, yet the "(blank)" still shows up in the slicer.

    I'm wondering if the fact that I'm using a macro to create the source data worksheet is part of the problem? When I manually copy and paste the data into a spreadsheet, I do not get this problem. When I created the macro, I did delete all blank space as part of the macro, and indeed blank space doesn't show up in the worksheet created from the macro. Yet the "blank" still appears in the 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. VBA Not removing "0" from Pivot table
    By Martin Putwain in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-27-2014, 12:46 PM
  2. removing "Select All" and limiting filter choices in a Pivot table
    By jettabar99 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-25-2013, 09:07 AM
  3. Replies: 2
    Last Post: 06-06-2013, 12:45 PM
  4. Pivot Table Field - Blank Cells without text "(blank)"
    By WRX in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-19-2013, 12:10 PM
  5. Removing "0.00" entries from Pivot Table
    By ojkingston in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 04-09-2008, 10:17 AM

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