Both pivot tables are based on data that is manually typed in, no formulas.
All my pivot tables are the same, they do not count blank cells, in this
workbook and all workbooks. This is why I thought there was something on the
Excel side and not within the pivot table. Both of us work for the same
company and are using the same version of Excel.

"Sune Fibaek" wrote:

Sorry, I'm drawing all blanks then. I can't even replicate the problem. Where
is the data comming from (manually typed in, generated by a query, formula
based)? What happens if you start with a blank workbook and manually enter
data that mirrors (some of) your current data and then make a PT based on
that?

"mtg girl" wrote:

Yes, there is data in the 3 rows. My Pivot Table is counting a non-numeric
field and there are 3 records that are blank in that field. When I double
click on what should be the total (for the blank fields) it drills down with
the 3 rows. The Grand Total also does not include the number of blank
fields.
All of my Pivot Tables are this way, I have already tried to delete and
re-do the Pivot Table. I was thinking that there is something on my Excel
workbook set-up that might be different than the person that sent me a Pivot
Table with the blank fields totaled, but I wasn't able to find anything under
the Tools/Option. I am not sure where else to look.

"Sune Fibaek" wrote:

Hi

This may be a rather daft question, but are you sure there is any data in
the blank cells in your source data? It the blank rows contain data there
should be a count, sum, whatever in your table. If there is endeed data try
selecting the entire range and make a new table.

HTH.

/Sune

"mtg girl" wrote:

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.