Thread: GETPIVOTDATA
View Single Post
  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

The GETPIVOTDATA function, like some other functions, only returns data
for references in the same file, or another open file.

http://support.microsoft.com/default.aspx?id=299303

Sho wrote:
I am using Excel 2003. When linking to a Pivot table in another worksheet it
automatically uses the GETPIVOTDATA function e.g. =GETPIVOTDATA("Cost",'[test
pivot 2.xls]Sheet1'!$A$3,"Name","Anne Murphy")

I then amend this formula to link it to a cell on another sheet e.g.
=GETPIVOTDATA("Cost",'[test pivot 2.xls]Sheet1'!$A$3,"Name","Anne Murphy")+A10

When I next open the file (the one that has the link and not the Pivottable
I see REF!#. This only updates with the answer when I go and open the source
that contains the pivot table.

Any idea how to see the answer straight away without having to open the
source file?

Thanks



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html