=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

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

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