Thread: Dont Show Zero Values
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
  
Posts: 10,593
Default 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


Reply With QuoteReply With Quote