View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
pj
 
Posts: n/a
Default Why does (blank) display on pivot table

I have created a pivot table and a couple of columns that I have used have no
data in them. However those columns are displaying (blank) in the pivot
table. I need it to not display anything so that once the pivot is printed
the field can be written in.

I have deleted all data in those columns, under 'options' I have checked
'For empty cells show...' and erased the field next to it but it still
displays in the pivot table as (blank).

Your thoughts...thanks

JP