I have several Pivot table charts and in each of my colums on the main data sheet there are drop downs and some if functions. The Pivot Tables are counting these cells. Although the cells are technically blank the pivot table will not exclude them. I could remove "blank" from each of my fields, however this a good way for me to verify that my database is being updated correctly. Any help would be greatly appreciated. Exhausted from searching the web in vain.