Pivot table magic
EXCEL 2007
Right click somewhere inside the Pivot Table and click on PivotTable Options
.. . .
PivotTable Options window should launch
Layout & Format tab / in here there is a box called:-
For empty cells show:
Place NA in the above cell.
I think that the above should give you what you want.
If you agree please hit Yes.
Thanks.
"bill_ball" wrote:
i want to see NA in all cells where data is empty in pivot table. Is
possible without vba?
thanks in advance
--
bill_ball
.
|