| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
=GETPIVOTDATA
When linking data from a pivot table I am getting
=GETPIVOTDATA("Size",$A$3,"Name",1) If I'm not mistaken on version prior 2003 I used to get the cell reference example =A3 Is it possible to get the cell reference as before ? Hope to have explained myself |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
=GETPIVOTDATA
See here
http://www.contextures.com/xlPivot06.html -- Allllen "refar" wrote: When linking data from a pivot table I am getting =GETPIVOTDATA("Size",$A$3,"Name",1) If I'm not mistaken on version prior 2003 I used to get the cell reference example =A3 Is it possible to get the cell reference as before ? Hope to have explained myself |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
=GETPIVOTDATA
Cheers Problem solved :)
"Allllen" wrote: See here http://www.contextures.com/xlPivot06.html -- Allllen "refar" wrote: When linking data from a pivot table I am getting =GETPIVOTDATA("Size",$A$3,"Name",1) If I'm not mistaken on version prior 2003 I used to get the cell reference example =A3 Is it possible to get the cell reference as before ? Hope to have explained myself |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
