It appears that GETPIVOTDATA only works when the workbook with the pivottable
is open. A number of other functions, such as SUMIF, require the source
workbook to be open.

Here is a workaround: Put the GETPIVOTDATA formulas in another sheet in
workbook with the pivottable. Then link to those cells from the other
workbook. I prefer to name each cell I am going to link to from another
workbook; this ensures that the links work if the linked cells are moved in
the source workbook, and the range names help to identify what each link is
for.

Hope this helps,

Hutch

"Mikmac" wrote:


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