GETPIVOTDATA issue

[Meredith]

I have some files that are linking to a pivot table in another workbook with the GETPIVOTDATA function.

For some reason, when I open one of those files without having the pivot table file open, the formula returns #REF's.

Other formulas like vlookups don't have this issue. They just keep the dame data that was in the file when it was saved unless I choose "update values" or open the otherfile.


Thoughts?

 

[Domski]

I'm afraid the GETPIVOTDATA function won't work on external files that are not open.

Not quite sure of the reason but I'd guess it's down to the way the cache that the pivot table's based on is calculated or stored.