Does anyone know how to turn off the GetPivotData function?

[Scott]

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.

 

[Ron Coderre]

....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