hide (blank) in pivot table
 

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

hide (blank) in pivot table
 

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.

"Nynke" wrote:

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