Question Locked
Excel returns #REF! when using GETPIVOTDATA function
0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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!