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

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