Does anyone know how to turn off the GetPivotData function?

[Guest]

The new version of Excel automatically prefills the formula with the
GetPivotData function when I try to use Pivot Table data. I don't want to
have this prefilled. How do I disable this.

 

[Guest]

....and Thank You to you too...

Like I say in my Excel classes:
If you think Excel should be able to do something, it usually can. You just
have to look in the right place.

Evidently, I never pursued this one far enough.

••••••••••
Regards,
Ron

 

[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