LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 57
Default 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




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Charts dont refresh to show changes to data sheet Chrisso Charts and Charting in Excel 0 August 26th 09 05:27 PM
dont show zero vaules in a chart Donald Watkins Charts and Charting in Excel 7 April 8th 09 04:40 AM
graph, data lables value, dont show zero values Madeleine Charts and Charting in Excel 1 February 14th 08 05:55 PM
Autofilter vba dont show filtered data PPesola Excel Programming 7 June 17th 04 07:42 AM
Dont show msgbox again Todd Huttenstine Excel Programming 4 April 30th 04 09:51 PM


All times are GMT +1. The time now is 05:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"