Debra Dalgleish has an addin that does lots of things--including this:
http://www.contextures.com/xlPivotAddIn.html
But you can just select one of those cells with (blank) in them and type what
you want instead.
enna49 wrote:
I have created a Pivot Table and where there is no data for that column I
would like to replace the (blank) with a comment etc. I know if you sum a
column etc you can put something in for empty cells. I do not want to hide
the row as there is a Property Name that is required to be seen
Thanks
Anne
--
Dave Peterson