hide (blank) in pivot table

N

Nynke

Dear All,

I created a pivot table where the empty cells are represented by (blanks).
By clicking on table options and selecting 'for empty cells show' I tried to
get rid of this (blank) description in my cells. However it will not go away.
Has anyone a suggestion for this problem?
Thanks a lot in advance.

Kind regards,
Nynke
 
P

Paul Mathews

In your pivot table click on a cell with a (blank) and put a space there.
All the (blank) items in that column should vanish.
 
Top