GETPIVOTDATA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two files linked using a GETPIVOTDATA formula. The Primary file
contains all my data and the Output file (which contains the GETPIVOTTABLE
formula) is for reporting purposes only.

However when I insert or delete a row in the Output file, it results in
#REF! for the GETPIVOTTABLE formula but when I then open the Primary data
file - the GETPIVOTTABLE formula automatically corrects itself.

Is there any way around having to have the primary file open to keep the
results in the Output file correct ?


Thanks
Kar
 
No, the GetPivotData formula only updates correctly if the file with the
pivot table is open.
 
Back
Top