How about just changing the (blank) to a space bar--just type a space bar right
in that cell in the pivottable itself.

Debra Dalgleish has a pivottable addin that does this and lots mo
http://www.contextures.com/xlPivotAddIn.html

PW wrote:

Whenever I have blank cells in the source data for my pivot tables in Excel,
instead of the table returning a blank value, it spells out "(blank)". Is
there any way to return a blank value, other than through changing all of the
blank cells in the source data to " "?

--

Dave Peterson