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...
 
Back
Top