Prev: how to find duplicate entry in one sheet and in workbook
Next: HELP needed to remove 2nd spreadsheet within a workbook
From: bill_ball on 30 May 2010 03:39

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

thanks in advance




--
bill_ball
From: trip_to_tokyo on 30 May 2010 11:05
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
> .
>
 | 
Pages: 1
Prev: how to find duplicate entry in one sheet and in workbook
Next: HELP needed to remove 2nd spreadsheet within a workbook