how do i link to a pivot table to get data dynamically

I need to link a sheet to a pivot table in the same workbook to get the data
value from the pivot table. This also has to be updated dynamically as the
pivot table changes. Can this be done and how.

You can use the GETPIVOTDATA function to extract data from the pivot
table. There's information in Excel's Help, and here:

http://www.contextures.com/xlPivot06.html

Michael001 wrote:
> I need to link a sheet to a pivot table in the same workbook to get the data
> value from the pivot table. This also has to be updated dynamically as the
> pivot table changes. Can this be done and how.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Hi Debra
Thank you very much for your response, I will give this a go and hopefully
resolve my problem.
Regards
Michael
"Debra Dalgleish" wrote:

> You can use the GETPIVOTDATA function to extract data from the pivot
> table. There's information in Excel's Help, and here:
>
> http://www.contextures.com/xlPivot06.html
>
> Michael001 wrote:
> > I need to link a sheet to a pivot table in the same workbook to get the data
> > value from the pivot table. This also has to be updated dynamically as the
> > pivot table changes. Can this be done and how.
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>