Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
link to pivot-table | Excel Discussion (Misc queries) | |||
How do I link a cell outside a pivot table to one inside the table | Excel Discussion (Misc queries) | |||
Change link in pivot table | Excel Worksheet Functions | |||
how do i link to a pivot table to get data dynamically | Excel Worksheet Functions | |||
Syntax Error - Using Microsoft Query and ODBC link to a table | Excel Discussion (Misc queries) |