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

Debra Dalgleish has a pivottable addin that has lots of features:
http://www.contextures.com/xlPivotAddIn.html
http://www.contextures.com/xlPivotAddIn02.html

Alan Synnott wrote:

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

--

Dave Peterson