How to remove blanks from slicers - Excel 2010 -

I've created a pivot table and added some slicers on it, one of them is showing "blank" in it, however I checked my data and made sure not blank cell is in that column. How can I remove it ?
LubinofSAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
nutschConnect With a Mentor Commented:
Try, in order of pain:
- refreshing the pivot
- changing the data source (to the same as it was)
- rebuilding the pivot with your blank-less data

Thomas
0
 
LubinofSAuthor Commented:
Nahh...I spent big time building the pivot table and calculations...never had blank data on it.
0
 
LubinofSAuthor Commented:
Would affect it the fact that I got blank data in other columns that dont have slicer ?
0
 
Jerry PaladinoCommented:
Check the data source range.  It is possible it may extend below your actual data and that will cause a blank to show in the pivot values.

To cross check, add the field in question to a "Report Filter" field and drop down the list of values.  You will also see the blank value there as well.   Think of a slicer as a visual representation of a Report Filter field.

Blank values in other fields will not effect the values show in a slicer.

HTH
Jerry
1
All Courses

From novice to tech pro — start learning today.