#REF when using GETPIVOTDATA from a Pivot Table from a different sheet

[albardit18]

I am using the GETPIVOTDATA formula to pull data from Pivot Tables onto a separate worksheet but when I open the file individually without the pivot table file open, I get a #REF error.

There are too many pivot tables I am using so they cannot be fitted in the same file that I am referencing from.

Is there a workaround to this?

[Philb1]

Wrap you formula in Iferror, something like =IFERROR(D1+D2,"") You'll get a blank cell if the formula returns an error.

[albardit18]

I should have been more descriptive, the GETPIVOTDATA formula pulls values in correctly, however, those values turn to #REF when the file with the pivot table is not open.

[albardit18]

Anyone has any idea on this?