GetPivotData

R

Rickie Gibson

I have created a PivotTable.
From this PivotTable I need some data.

I have used de function GetPivotData.
This works fine, if I use the function inside the same workbook.
If also works if the PivotTable is in another Workbook.

However if the workbook with the PivotTable is closed, then I get a
reference fault.

Is that normal? Must the table with the PivotTable be opened?

Thanks for any suggestions.
 
R

Roger Govier

Hi Rickie

Yes, that is the default position with GetPivotData - the source file must
be open.

--

Regards
Roger Govier

Rickie Gibson said:
I have created a PivotTable.
From this PivotTable I need some data.

I have used de function GetPivotData.
This works fine, if I use the function inside the same workbook.
If also works if the PivotTable is in another Workbook.

However if the workbook with the PivotTable is closed, then I get a
reference fault.

Is that normal? Must the table with the PivotTable be opened?

Thanks for any suggestions.


__________ Information from ESET Smart Security, version of virus
signature database 5418 (20100902) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 5418 (20100902) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 

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