how do I link pivot table data into a separate document?
 

I created a tab in the pivot table document with links to the pivot table
using the GETPIVOTDATA function. Then I moved the tab with the links into a
new file. When I closed the new file and opened it back up, I am full of
Reference errors. The GETPIVOTDATA function formula looks fine but does not
give me the data that I need.

Does anyone have any idea why?

how do I link pivot table data into a separate document?
 

The GETPIVOTDATA function, like some other functions, only returns data
for references in the same file, or another open file.

http://support.microsoft.com/default.aspx?id=299303

If you open the other workbook, the formula results should work correctly.

Hendy wrote:
I created a tab in the pivot table document with links to the pivot table
using the GETPIVOTDATA function. Then I moved the tab with the links into a
new file. When I closed the new file and opened it back up, I am full of
Reference errors. The GETPIVOTDATA function formula looks fine but does not
give me the data that I need.

Does anyone have any idea why?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html