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!
- Follow via:
- RSS
- Email Alert
Question
0
Votes
Excel returns #REF! when using GETPIVOTDATA function
Tags:
windows, security, software, database, career, it management, project management, networking, excel, programming, off-topic, ms query
13th Aug 2008
