Dont Show Zero Values
 

How can I stop zero vaules appearing in a pivot table?

TheRook

Dont Show Zero Values
 

ToolsOptionsView, uncheck Zero Values

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"TheRook" wrote in message
...
How can I stop zero vaules appearing in a pivot table?

TheRook

Dont Show Zero Values
 

Thanks, done that and it now shows a blank field. Can the pivot table be
formatted so that it does not show blank fields?

Regards

"Bob Phillips" wrote:

ToolsOptionsView, uncheck Zero Values

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"TheRook" wrote in message
...
How can I stop zero vaules appearing in a pivot table?

TheRook