GETPIVOTDATA and #Ref

[Leigh Ann]

When using the GETPIVOTDATA function and there is no data available for the
specified criteria, I get the #Ref error. Please give me the formula to
avoid this. Thanks - Leigh Ann

 

[Frank Kabel]

Hi
try
=IF(ISERROR(your_formula),"",your_formula)