GETPIVOTDATA from a closed book

S

serge

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.
 
R

Roger Govier

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
 
S

serge

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