Hi all,

I have a pivot table which is counting blank cells from the range of data that the pivot table is reading from.

I have been able to fix this by putting on a filter in the data table, highlighing all the blank cells only and then clearing them column by column.

The problem is the data table is 50 columns long, so it is quite time consuming to do this manually. The data table gets updated regularly so this is an ongoing problem.
Does anyone know of a faster solution to fix this problem?

many thanks,

Nicko