Disable automatic GETPIVOT

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

news.microsoft.com - 06 Jul 2006 10:27 GMT

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

Reply to this Message

Roger Govier - 06 Jul 2006 18:09 GMT

Hi

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

Signature

Regards

Roger Govier

> Whenever I reference to a field in a pivot table I get the
> "GETPIVOTDATA....." worksheet function. This would normally be OK but
[quoted text clipped - 8 lines]
>
> Nick

Reply to this Message

news.microsoft.com - 10 Jul 2006 10:54 GMT

Many thanks Roger it worked a treat

Nick

> Hi
>
[quoted text clipped - 14 lines]
> >
> > Nick

Reply to this Message

Roger Govier - 10 Jul 2006 21:19 GMT

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

Signature

Regards

Roger Govier

> Many thanks Roger it worked a treat
>
[quoted text clipped - 20 lines]
>> >
>> > Nick

Reply to this Message