My pivot table is not counting blank cells

I

IB

I have just switched to excel 07. In the previous version where i had blank
cells in a table, then created a pivot table for the data, the pivot table
would count the blank cells. When i do this same exercise in 07 the pivot
table seems to have a column heading that says 'blank' however it does not
count the blank cells (i.e. the blank column is not populated). I have
checked the cells with the isblank formula and they are definetly blank.

regards
 

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
Pivot Table 2
Doughnut Chart linked with the slicer in the pivot table 0
Populate a table based on check box status 2
Excel does not accept text format! 0
Setting column width in a table with a macro is not working 0

Top