The only way I’ve found that works is to format the cells in the pivot table with a custom format so that it hides the blank text values. If the screenshot I loaded doesn’t appear, use this setting in the ‘Custom’ field in the format cells dialog:
#,##0;(#,##0);#,##0; The semicolon separates the formatting in sequence for:
Positive value
Negative values
Zero values
Text Values
(Blank) is text so by putting nothing after the 4th semicolon, text values disappear. Afterward, if you select what looks like an empty cell, you will still see (blank) in the formula bar. It still there. you just can’t see it and it isn’t annoying.
