I have a Pivot Table that shows blank cells but does not calculate the number
of cells. There are 3 records with blanks.
No 262
Yes 2
(blank)
Grand Total 264

In a Pivot Table I received from someone else, the blank fields are totaled.
Shanna Cleveland 10
Soraya Guzman 2
Steve Vitale 1
(blank) 7505
Grand Total 7709

I have checked the Table Options and both Pivot Tables have a check mark in
the "for empty cells, show:". I can not figure out what else might be
different between the two tables. Also, both workbooks have "Zero Values"
checked in the Tools/Option/View.