G Guest Feb 24, 2004 #1 How do you suppress "(blank)" from showing up in a pivot table field Thanks ak
M miker1999 Feb 24, 2004 #2 I use a Condition Format that when cell is 'equal to' "(blank)" forma the cell to white (or you can change the font color to white)
I use a Condition Format that when cell is 'equal to' "(blank)" forma the cell to white (or you can change the font color to white)
G Guest Feb 25, 2004 #3 Thanks for the heads up... That's the work around I was using. I thought there was an option or something that would turn it off. It shows up on some pivots and not others. Do you know why Thanks ak
Thanks for the heads up... That's the work around I was using. I thought there was an option or something that would turn it off. It shows up on some pivots and not others. Do you know why Thanks ak
