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 pivottable open else there is zero i all cells? Why?

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


Please help me!!!--
Kind regards Michael