GETPIVOTDATA not working

[AnnWillmott]

Hi, I am referencing data in another workbook using GETPIVOTDATA.

In Workbook A, I click in the cell where I want to place the value, insert the = sign and then click on a field in the pivot table in Workbook B. This creates a GETPIVOTDATA formula that references Workbook B.

This kind of link works fine with Workbooks A & B. However, I cloned Workbook B and created Workbook C. Workbook A can't reference Workbook C. When I click on the = sign, then switch to Workbook C and click on the pivot table, I lose the connection to Workbook A and the formula is not created.

I can't see any fundamental difference between Workbook B and C, though they have different data, but it has the same number of sheets with the same formulas - functionally, it's a clone. This seems like a bug. Has anyone else seen this?

 

[AnnWillmott]

Also, I do have the "Generate GetPivotData" ON in the pivot table in Workbooks B and C.

 

[xenou]

I'm not sure what you mean by clone. Did you copy the file? Do a File | Save As?

It is possible that the pivot cache is a shared source between the two files, somehow. It may be best to re-create it in the new workbook, or try again. And not to have two workbooks with the same pivot table data - that just sounds like trouble.

 

[AnnWillmott]

Oddly enough, this problem fixed itself after a couple of hours of messing with it! The "cloned" table (I created it by Save As) has different data, actually - but I copied my spreadsheets to create separate version for separate television seasons. Anyway, if I find out what caused it, I'll post back. Thank you!

 

[RoryA]

It sounds as though you had the two workbooks open in different instances of Excel?