Excel returns #REF! when using GETPIVOTDATA function

When I open my file it asks to update or don’t upadate. If I choose UPDATE all my formulas that has GETPIVOTDATA returns #REF!. Then if I double click on the cell it opens the file that has the pivot table and it updates. Seems that Excel does not calculate those formulas.
If I have the pivot opened and open the file it will update automatically.

Please help!