GetPivotData #Ref Error

Hi Folks,

I have a sheet with pivot table, from which I did some calculations using GetPivotData, mostly Im only summing up the cells.
The issue is, that some of the cells from the calculation formula may not be available each month and therefore Im getting a #REF error.

Is there any way how to get the formula working if one of the cells in formula is not available?

Thanks!
Lukas

Hi,

Probably you can add an IFERROR(GETPIVOTDATA....................,0) condition and get the formula working.