GETPIVOTDATA issue

Meredith

New Member
Joined
Oct 2, 2006
Messages
26
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?
 

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

Domski

Well-known Member
Joined
Jan 18, 2005
Messages
7,292
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,090
Messages
5,545,893
Members
410,711
Latest member
Josh324
Top