The GetPivotData formula should be automatically created, if you click
on a data cell in the pivot table, in Excel 2002 or later version.

However, the formula can't be updated unless the workbook with the pivot
table is open.

aliya.pawaskar wrote:
Hi,

I need help in using the 'GetPivotData' formula. I need to link the data
from one workbook to another workbook.


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com