Does GETPIVOTDATA work if you have two pivot tables in one workbook?

[jess777]

Hi,

I have two pivot tables on different sheets inside the same workbook
Each pivot table gets their data from separate sheets as well.

When I use GETPIVOTDATA it always gives me REF#!

However GETPIVOTDATA works fine if there is only one pivot table in the workbook.

Is there something I have to add to my formula to specify which pivot table I need the data to come from?

Thanks in advance for any help!

(i am windows 7 and office 2007)