ExcelBanter - Pivot Table Refreshing

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Pivot Table Refreshing (https://www.excelbanter.com/excel-discussion-misc-queries/168033-pivot-table-refreshing.html)

Yuanhang

Pivot Table Refreshing

After I update the data that originates a pivot table, the pivot table
recognizes some blanks as zero. In other words, if I have to leave some cells
blank, is there any way that may not show "0" as an item in the pivot table?

All times are GMT +1. The time now is 01:16 PM.