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


Scott wrote:
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.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html