ExcelBanter - Pivot table magic

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Pivot table magic (https://www.excelbanter.com/excel-discussion-misc-queries/264895-pivot-table-magic.html)

bill_ball

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

bala_vb

Quote:

Originally Posted by bill_ball (Post 957104)

i want to see NA in all cells where data is empty in pivot table. Is possible without vba?

thanks in advance

which version of excel you are using.

i think you can try pivot table option, for empty value show NA

all the best

bala_vb

Quote:

Originally Posted by bill_ball (Post 957104)

i want to see NA in all cells where data is empty in pivot table. Is possible without vba?

thanks in advance

yes, this is possible in both excel 2003 and excel 2007 without vba. please revert back if i didnot understand the issue properly

trip_to_tokyo[_3_]

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
.

All times are GMT +1. The time now is 06:54 AM.