Pivot table blank/empty cells

G

Guest

hi there, I have a large amount of source data with a lot of empty cells. I
have converted the data to Pivot Tables for ease of use. I want the empty
cells in the source data to be empty in the PT, BUT no matter what I try,
they always display as (blank). I have changed the tick box within the Field
Settings option, but nothing happens. I could cheat, and fill in the source
data with spaces, but I would prefer to do it right. The MS help has no
options other than the Field Settings option above.

Cheers
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table blank cell 2
pivot table (blank) 2
Pivot Table - Hide (blank) 1
Pivot table 1
Totaling blank cells in Pivot Tables 8
Keep the word (blank) out of Pivot Table? 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Pivot Table show Zero problem 2

Top