GETPIVOTDATA Link to External Pivot Table

B

Bill Ba

In a workbook, I made a GETPIVOTDATA formula to link to a Pivot table in
another workbook, but...

If I open the workbook with the formula while the pivot table workbook is
closed, and then update links, I receive the dreaded "#REF!" error in the
cell where the formula is. (By the way, the fomula points to the correct
full path of the starting cell of the pivot table, and the formula works
correctly when the pivot table file is open.)

Is there any way to make GETPIVOTDATA to read pivot tables in other
workbooks that are closed???

I would prefer to use the GETPIVOT DATA formula rather than formulas
directly referencing cells in case the table format changes.

Thanks for any advice.
 

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

Top