Pivottable update Excel 2007

M

Mikmac

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top