when reference a cell within a pivot table it doesnt give me the rc 2

[Davefeet]

It give me =GETPIVOTDATA("Sum of Year",A3,"Month","JAN&quot
how can I turn this off?

I want it to give me the cell "A3" instead when I point to it, it gives me this =GETPIVOTDATA crap.

It didnt do this in 97



SLC: Greatest snow on earth!!!

 

[KenWright]

View / Toolbars / PivotTable Toolbar - Look for a square icon with a diagonal arrow on it that says 'Generate GetPivotData' when you hover over it. Clcik on that to toggle the feature on/off.

Regards
Ken.............

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

----------------------------------------------------------------------------

 

[luceze]

As far as I know there is no way to turn it off. You will have to manually enter the cell reference instead of selecting the cell to return the cell reference.

HTH,
Eric

 

[Davefeet]

Ken hit it right on


SLC: Greatest snow on earth!!!

 

[luceze]

Good one Ken!

Eric