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 |
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) |