How do I use turn GETPIVOTDATA function off?

[Guest]

I want to reference PivotTable data in a formula outside the PivotTable
report without invoking the GETPIVOTDATA function. For example I want to
simply point and click to a cell in the PivotTable (i.e. =A3). I could then
copy this relative reference to other cells. As it now stands, when I point
and click I automatically invoke the GETPIVOTDATA function, which creates
absolute references which I don't want.

 

[John Michl]

Type in the formula instead of pointing and clicking.

-John

 

[Ken Wright]

View / Toolbars / Pivottable

Now hover over each icon till you find the GETPIVOTDATA toggle button and
then click to turn it off.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission
------------------------------­------------------------------­----------------

 

[Debra Dalgleish]

There are instructions here for adding the Generate GetPivotData button
to a toolbar, and toggling the feature on and off:

http://www.contextures.com/xlPivot06.html