B bill_ball May 30, 2010 #1 i want to see NA in all cells where data is empty in pivot table. I possible without vba? thanks in advanc
i want to see NA in all cells where data is empty in pivot table. I possible without vba? thanks in advanc
T trip_to_tokyo May 30, 2010 #2 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.
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.