hide 0 values in pivot table (2003)

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

Hi I can not find how to hide 0 fields in pivot table in office 2003.

thanks tim
 
You can hide blank values but not zero values (at least not built in the
pivot table options), you can hide all zero values under tools>options>view
and uncheck zero values. Debra Dalgleish has posted code for hiding zero
fields

http://tinyurl.com/ca7gr
 
You must log in or register to reply here.

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

Pivot Tables in Excel 2007 vs 2003 1
"Pivot Table" option in Add / Remove buttons for Pivot Table Toolbar 1
Pivot table report invalid 0
Export Pivot table 1
Consolidate Pivot Tables/Cache using Excel 2003 1
Pivot Table Help! 1
PIvot Table top Values 1
pivot table loosing decimals (vba) 1

Back
Top