View Single Post
  #1   Report Post  
MarkfromAZ
 
Posts: n/a
Default How do I remove the (blank) from an excel pivot table?

I am trying to create a pivot table from a liston an excel spreadsheet. Many
of the items on the list will be blank. On the pivot table, the blank items
show up as (blank) - I want the cell to be empty! I tried setting the table
empty values but that doesn't work...any help would be greatly apprecated...