Pivot table magic

B

bill_ball

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup with Pivot Table 1
Adding to an existing Pivot Table 7
pivot table data 2
Pivot table filter list - listing irrelevant subcategorys 1
Pivot Table - Changes 5
Question on the occupied field of the pivot table in excel spreadsheet 0
Pivot table seems to round my figures up! 2
Refreshing Pivot Table on a protected spreadsheet tab 1

Top