I couldn't figure out what is acutally in the cells, Excel says:
The cell is not blank.
It is not a number.
It's length is zero.
I also tried the Code function to find an ascii value and got an error.
Why not make the pivottable in Qlikview?
My other thought is to write an Excel macro that clears the contents of those cells.