Disable automatic GETPIVOT

Whenever I reference to a field in a pivot table I get the
"GETPIVOTDATA....." worksheet function. This would normally be OK but
this is an Absolute reference and I can't figure out how to get it to
make it a relative reference.

The only way I can do it is by taking out the formula and manually
entering the cell reference - ie "A1". Is there any way the GETPIVOT
function can be turned off??


Thanks

Nick

Hi

Take a look at Debra Dalgleish's site for information on the
GetPivotData function
http://www.contextures.com/xlPivot06.html

--
Regards

Roger Govier


"news.microsoft.com" <pinickitty@hotmail.com> wrote in message
news:OL9qq5NoGHA.4616@TK2MSFTNGP05.phx.gbl...
> Whenever I reference to a field in a pivot table I get the
> "GETPIVOTDATA....." worksheet function. This would normally be OK but
> this is an Absolute reference and I can't figure out how to get it to
> make it a relative reference.
>
> The only way I can do it is by taking out the formula and manually
> entering the cell reference - ie "A1". Is there any way the GETPIVOT
> function can be turned off??
>
>
> Thanks
>
> Nick
>
>

Many thanks Roger it worked a treat

Nick
"Roger Govier" <roger@technologyNOSPAM4u.co.uk> wrote in message
news:OcLfk7RoGHA.1208@TK2MSFTNGP04.phx.gbl...
> Hi
>
> Take a look at Debra Dalgleish's site for information on the
> GetPivotData function
> http://www.contextures.com/xlPivot06.html
>
> --
> Regards
>
> Roger Govier
>
>
> "news.microsoft.com" <pinickitty@hotmail.com> wrote in message
> news:OL9qq5NoGHA.4616@TK2MSFTNGP05.phx.gbl...
> > Whenever I reference to a field in a pivot table I get the
> > "GETPIVOTDATA....." worksheet function. This would normally be OK but
> > this is an Absolute reference and I can't figure out how to get it to
> > make it a relative reference.
> >
> > The only way I can do it is by taking out the formula and manually
> > entering the cell reference - ie "A1". Is there any way the GETPIVOT
> > function can be turned off??
> >
> >
> > Thanks
> >
> > Nick
> >
> >
>
>

Well, thanks to Debra really, but many thanks for the feedback

--
Regards

Roger Govier


"news.microsoft.com" <pinickitty@hotmail.com> wrote in message
news:usc1fbApGHA.2452@TK2MSFTNGP03.phx.gbl...
> Many thanks Roger it worked a treat
>
> Nick
> "Roger Govier" <roger@technologyNOSPAM4u.co.uk> wrote in message
> news:OcLfk7RoGHA.1208@TK2MSFTNGP04.phx.gbl...
>> Hi
>>
>> Take a look at Debra Dalgleish's site for information on the
>> GetPivotData function
>> http://www.contextures.com/xlPivot06.html
>>
>> --
>> Regards
>>
>> Roger Govier
>>
>>
>> "news.microsoft.com" <pinickitty@hotmail.com> wrote in message
>> news:OL9qq5NoGHA.4616@TK2MSFTNGP05.phx.gbl...
>> > Whenever I reference to a field in a pivot table I get the
>> > "GETPIVOTDATA....." worksheet function. This would normally be OK
>> > but
>> > this is an Absolute reference and I can't figure out how to get it
>> > to
>> > make it a relative reference.
>> >
>> > The only way I can do it is by taking out the formula and manually
>> > entering the cell reference - ie "A1". Is there any way the
>> > GETPIVOT
>> > function can be turned off??
>> >
>> >
>> > Thanks
>> >
>> > Nick
>> >
>> >
>>
>>
>
>