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 " "?

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

Dave,
Thank you for the reply- however I use one data source for several different
tables, and there are several fields that contain blanks. I think changing
the original source is probably the best solution. In the meantime, I took
your advice and wrote up a quick macro to find and replace the text-

Contextures is a very helpful site. Thank you and best regards,
PW

"Dave Peterson" wrote:

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

When I want cell to look empty, I use =""

I can still check for: =if(a1="",...) and it's easier to notice in the formula
bar than " ".



PW wrote:

Dave,
Thank you for the reply- however I use one data source for several different
tables, and there are several fields that contain blanks. I think changing
the original source is probably the best solution. In the meantime, I took
your advice and wrote up a quick macro to find and replace the text-

Contextures is a very helpful site. Thank you and best regards,
PW

"Dave Peterson" wrote:

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


--

Dave Peterson