Pivot Table formula

  • Thread starter Thread starter aliya.pawaskar
  • Start date Start date
A

aliya.pawaskar

Hi,

I need help in using the 'GetPivotData' formula. I need to link the data
from one workbook to another workbook.
 
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.
 
You must log in or register to reply here.

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

Similar Threads

Getpivot data dynamic reference 1
GETPIVOTDATA #REF! error XL2003/2010 1
2003 formula for Pivot 1
Do not want formulas to reference old workbook. 10
Rows disappear in pivot table 1
Pivot Table Calculated field error 1
Error when Formula references a pivot table in an external workboo 2
Pivot Table Comparisons in Excel 2007 2

Back
Top