+ Reply to Thread
Results 1 to 2 of 2

Excel how to remove slicer blank???

  1. #1
    Registered User
    Join Date
    08-18-2015
    Location
    singapore
    MS-Off Ver
    2013
    Posts
    4

    Unhappy Excel how to remove slicer blank???

    Currently I am using the formula
    =OFFSET(SHEET1!$A$9,0,0,(COUNTA(SHEET1!$A:$A)-1),12) (my cell starts at A9)

    Im using this formula because it can auto update the database to my pivottable instead of manual changing the data source.

    However, my slicer still shows (blanks), NA, and *empty cell*

    Can anyone help me please. Or is my approach wrong and there is a better way to auto update my database to my pivottable?

    Thank you.

    p.s
    image of my error
    error.png
    Last edited by Crizlee; 08-18-2015 at 12:11 PM. Reason: ADD ON

  2. #2
    Registered User
    Join Date
    08-18-2015
    Location
    singapore
    MS-Off Ver
    2013
    Posts
    4

    Re: Excel how to remove slicer blank???

    P.S my pivottable also shows (blanks) etc...

+ 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. [SOLVED] Concatenate If Blank - remove blank line if first cell is blank
    By ker9 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-27-2014, 02:14 PM
  2. Make one slicer mirror filters of another slicer
    By IbenezPrez in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-28-2014, 02:00 PM
  3. Replies: 1
    Last Post: 02-07-2013, 07:14 AM
  4. Slicer Macro - unfilter another slicer on selection
    By chadheins in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-24-2012, 10:41 AM
  5. [SOLVED] Change Chart Title Depending on a Slicer - slicer advice
    By JungleJme in forum Excel General
    Replies: 8
    Last Post: 08-17-2012, 07:59 AM
  6. remove blank rows in excel
    By angie.chang in forum Excel General
    Replies: 2
    Last Post: 06-13-2012, 10:15 AM
  7. how to remove blank cells in excel
    By Landa in forum Excel General
    Replies: 8
    Last Post: 08-28-2006, 04:29 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