ExcelBanter - GETPIVOTDATA

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - GETPIVOTDATA (https://www.excelbanter.com/excel-worksheet-functions/164286-getpivotdata.html)

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.

kar wrote:
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 ?

--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html