disable get pivot table function

[Guest]

Want to create formulas outside of a pivot table yet still reference the data
within the pivot table. I can manually write the cell name such as
=E7+E9....but want to create the formula by clicking in the cell without
automatically getting the getpivottable funtion. Is it possible to disable
this function? I use the get pivot table function quite frequently and
successfuly but in this instance don't want it.

 

[Roger Govier]

Hi Wanda

Debra Dalgleish explains how to do this at her site
http://www.contextures.com/xlPivot06.html

 

[tom]

I have the same problem. It worked great in earlier Excel version but now
2003 has this anoying GETPIVOTTABLE function. Did you ever find a way to
disable this?

 

[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

When it's turned off, you will create a normal reference when you click