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