Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivot table magic
i want to see NA in all cells where data is empty in pivot table. Is possible without vba?
thanks in advance |
#2
|
|||
|
|||
Quote:
i think you can try pivot table option, for empty value show NA all the best
__________________
Thanks Bala |
#3
|
|||
|
|||
yes, this is possible in both excel 2003 and excel 2007 without vba. please revert back if i didnot understand the issue properly
__________________
Thanks Bala |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Magic Formula Appearance | New Users to Excel | |||
IDE add-on VB Magic? | Excel Discussion (Misc queries) | |||
My new book is available -- "This isn't Excel, it's Magic" | Excel Discussion (Misc queries) | |||
Magic Cells | Excel Discussion (Misc queries) |