software

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 he

www.contextures.com/xlPivot06.html

Michael001 wrote:
gt; I need to link a sheet to a pivot table in the same workbook to get the data
gt; value from the pivot table. This also has to be updated dynamically as the
gt; pivot table changes. Can this be done and how.--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.htmlHi Debra
Thank you very much for your response, I will give this a go and hopefully
resolve my problem.
Regards
Michael
quot;Debra Dalgleishquot; wrote:

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