Pulling data from remote pivot table

C

Chris

I have had some problems pulling data from a pivot table
that resides in another file. It seems that the data file
must be open for the pulling document to display the
updated values. If I update and the source file is not
open, I get a #REF error.

Anyone seen this? What are my options here? I don't want
to have to open the source file every time I need to
update.

Thanks!
-Chris
 
Top