Hi,

have a pivottable in one workbook. In another one i use GETPIVOTDATA and use
update to get the data. The problem is that it only works when i have the
workbook with the pivotable open? Why?

Is it possible also automatically update the data without using update?


--
Kind regards Michael