R ryguy7272 Mar 12, 2008 #2 Click the down arrow on the Row or Column, and uncheck zero. You could also try double-clicking one of the pivots and choose Subtotals > None > OK. Hope that helps. Regards, Ryan---
Click the down arrow on the Row or Column, and uncheck zero. You could also try double-clicking one of the pivots and choose Subtotals > None > OK. Hope that helps. Regards, Ryan---
T Tom Hutchins Mar 12, 2008 #3 I don't know if you can hide zeros just for the pivot table, but if you select Tools >> Options >> View and uncheck Zero values, they will be hidden everywhere on that sheet (including the pivot table). Hope this helps, Hutch
I don't know if you can hide zeros just for the pivot table, but if you select Tools >> Options >> View and uncheck Zero values, they will be hidden everywhere on that sheet (including the pivot table). Hope this helps, Hutch
