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.