Pivot Table Link Error
 

I have a spreadsheet that I've linked to another spreadsheet's pivottable. So
it has a formula with GETPIVOTDATA. I can send this others, but as soon as
they save it their desktop or anywhere else. The Pivottable is lost and goes
to Zero, like the data isn't there. Does anyone know why this is happening,
and if so, is there anything I can do to get my worksheet to retain the
values from the pivottable, so they don't go to zero?

Thanks
Vicks

Pivot Table Link Error
 

If they open both workbooks, does the pivot table work correctly?

Vick wrote:
I have a spreadsheet that I've linked to another spreadsheet's pivottable. So
it has a formula with GETPIVOTDATA. I can send this others, but as soon as
they save it their desktop or anywhere else. The Pivottable is lost and goes
to Zero, like the data isn't there. Does anyone know why this is happening,
and if so, is there anything I can do to get my worksheet to retain the
values from the pivottable, so they don't go to zero?

Thanks
Vicks


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

Pivot Table Link Error
 

Yes, it works correctly, and it works correctly until the file is saved
again. Then the data all goes to zero.

"Debra Dalgleish" wrote:

If they open both workbooks, does the pivot table work correctly?

Vick wrote:
I have a spreadsheet that I've linked to another spreadsheet's pivottable. So
it has a formula with GETPIVOTDATA. I can send this others, but as soon as
they save it their desktop or anywhere else. The Pivottable is lost and goes
to Zero, like the data isn't there. Does anyone know why this is happening,
and if so, is there anything I can do to get my worksheet to retain the
values from the pivottable, so they don't go to zero?

Thanks
Vicks


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