Pivot Table Refreshing

Y

Yuanhang

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?
 

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

Dealing with a Pivot Table (when I don't want to) 0
Pivot Table cell values 1
Pivot Table Counting Text Data 0
Excel does not accept text format! 0
Slicers and Calculated Items in Pivot Table 2
Scientific Notation 1
Pivot table overlaps another pivot table - how to find it 0
Excel 2007 vlookup with Pivot table 0

Top