GETPIVOTDATA from a closed book

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear all,

i used some the getpivotdata formula from one book to another (both open).
everything was working until i closed it.
So my question: is there anyway to use getpivotdata from a closed book?

(i tried to update the link, but nothing was working..)

thank you.
 
Hi Serge

GetPivotData will only work on an open source workbook.

You could use GetPivotData to extract the data to another sheet in the
workbook, then reference those fixed cells in the workbook, even if it is
closed
 
ok
thanks !

Roger Govier said:
Hi Serge

GetPivotData will only work on an open source workbook.

You could use GetPivotData to extract the data to another sheet in the
workbook, then reference those fixed cells in the workbook, even if it is
closed
Click to expand...
 
You must log in or register to reply here.

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

Similar Threads

Getpivotdata Function 3
GetPivotData Reference Range 2
getpivotdata relative reference? 3
GETPIVOTDATA function on pivot filter 0
GETPIVOTDATA Link to External Pivot Table 1
#Value! Errors from a GETPIVOTDATA function 2
sum of getpivotdata() 0
Pivot Table GETPIVOTDATA 2

Back
Top