Hi,

Let me explain the setup...

I have 3 workbooks.
wkbk1 contains a list of source data.
wkbk2 contains pivot tables based on the source data.
wkbk3 contains reports using the worksheet formula GETPIVOTDATA.

When I open up wkbk1 and update the values in the report show #REF.
However, When I then open up wkbk2 the values in wkbk1 update.

How can I get the values to display on just opening wkbk1.

A sample formula in the report is as follows:

=GETPIVOTDATA("Sum of AOT GBPNet",'V:\Broker
Disclosure\Reporting\[TD.xls]PT AOT Combined'!$A$5)

TIA,
Matt.


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=390539