Software

Our forums are currently in maintenance mode and the ability to post is disabled. We will be back up and running as soon as possible. Thanks for your patience!

Question

Locked

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