Pivot Table formula

A

aliya.pawaskar

Hi,

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

Debra Dalgleish

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.
 
Top