Keep the word (blank) out of Pivot Table?
 

I don't want to see that word (blank) scattered throughout my Pivot Table.

So, while in a PT Worksheet, I select the Excel Replace feature and in the
Find What box I type (blank) and in the Replace With box I put two spaces.
That works in getting rid of the word (blank) throughout the PT. Amazingly,
without me opening the Replace feature ever again, I can Refresh the PT and
the Replace setup I did initially is applied over and over again to the PT,
even to new records that may get added over time.

This has solved my issue but seems to be a bizarre and fragile way of
dealing with the issue. Plus, I've never seen the Replace feature work
repetitively and automatically until now.

So, is there any way to suppress the word (blank) from being filled into a
PT when it is created or refreshed using some PT setup feature or option?
I'd like to just see an empty cell where the word (blank) is appearing now
when I create a PT for the first time and everytime I Refresh it.

Thanks .... Rick

Keep the word (blank) out of Pivot Table?
 

I don't think there's an option to suppress this.

You could fill each of the cells with a single space (yech, don't do this!).

Or you could take a look at Debra Dalgleish's pivottable addin.
http://contextures.com/xlPivotAddIn.html
http://contextures.com/xlPivotAddIn02.html

Jeeslawees wrote:

I don't want to see that word (blank) scattered throughout my Pivot Table.

So, while in a PT Worksheet, I select the Excel Replace feature and in the
Find What box I type (blank) and in the Replace With box I put two spaces.
That works in getting rid of the word (blank) throughout the PT. Amazingly,
without me opening the Replace feature ever again, I can Refresh the PT and
the Replace setup I did initially is applied over and over again to the PT,
even to new records that may get added over time.

This has solved my issue but seems to be a bizarre and fragile way of
dealing with the issue. Plus, I've never seen the Replace feature work
repetitively and automatically until now.

So, is there any way to suppress the word (blank) from being filled into a
PT when it is created or refreshed using some PT setup feature or option?
I'd like to just see an empty cell where the word (blank) is appearing now
when I create a PT for the first time and everytime I Refresh it.

Thanks .... Rick

--

Dave Peterson

Keep the word (blank) out of Pivot Table?
 

Thanks Dave. I think I'll just keep hoping my Replace (blank) with 2 spaces
exercise stays in place after each Refresh. Even if it doesn't, I can always
redo it, it's quick to do. The only downside of using my Replace command is
if any of my 2 space replacements get inserted in a column I want to sort,
the sort will get screwed-up. Oh well, such is Microsoft.

"Dave Peterson" wrote:

I don't think there's an option to suppress this.

You could fill each of the cells with a single space (yech, don't do this!).

Or you could take a look at Debra Dalgleish's pivottable addin.
http://contextures.com/xlPivotAddIn.html
http://contextures.com/xlPivotAddIn02.html

Jeeslawees wrote:

I don't want to see that word (blank) scattered throughout my Pivot Table.

So, while in a PT Worksheet, I select the Excel Replace feature and in the
Find What box I type (blank) and in the Replace With box I put two spaces.
That works in getting rid of the word (blank) throughout the PT. Amazingly,
without me opening the Replace feature ever again, I can Refresh the PT and
the Replace setup I did initially is applied over and over again to the PT,
even to new records that may get added over time.

This has solved my issue but seems to be a bizarre and fragile way of
dealing with the issue. Plus, I've never seen the Replace feature work
repetitively and automatically until now.

So, is there any way to suppress the word (blank) from being filled into a
PT when it is created or refreshed using some PT setup feature or option?
I'd like to just see an empty cell where the word (blank) is appearing now
when I create a PT for the first time and everytime I Refresh it.

Thanks .... Rick

--

Dave Peterson