Pivot table - not show all data

[george hart]

Hi

I have a pivot table that's not showing all the data in all cells, yet if I rearrange the columns wthin the pivot it works? Or, if I delete the pivot and start again, that also works?

The data range is fine and, for example, say i'm looking up column A1:D34. The pivot shows it's clearly loking at that range but certain cells are blank when there's clearly data in it within that range?

The pivot has been working for months ok, and it's only just started to happen?? I can't figure it out...

Any help will be most appreciated