GETPIVOTDATA from a closed book

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

serge - 02 Nov 2007 05:36 GMT

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.

Reply to this Message

Roger Govier - 02 Nov 2007 14:01 GMT

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

Signature

Regards
Roger Govier

> Dear all,
>
[quoted text clipped - 5 lines]
>
> thank you.

Reply to this Message

serge - 05 Nov 2007 01:05 GMT

ok
thanks !

> Hi Serge
>
[quoted text clipped - 13 lines]
> >
> > thank you.

Reply to this Message