Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot table (blank) | Excel Discussion (Misc queries) | |||
Pivot Chart Created from Pivot Table is Blank | Charts and Charting in Excel | |||
How to clear the word '(blank)' from a cell in a Pivot Table | Excel Discussion (Misc queries) | |||
Pivot table creates blank table | Charts and Charting in Excel | |||
removing the word (blank) from pivot table cells | Excel Discussion (Misc queries) |