Excel returns #REF! when using GETPIVOTDATA function

By mivanos19 ·
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!

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums