getpivotdata

[Guest]

How can the automatic getpivotdata function be turned off in Excel 2003?
Discussion: Every time an equation in Excel 2003 uses data in the pivot
table it invokes the getpivotdata function automaticly. Previous Excel
versions did not do this.
Now if the specific cell address needs adjusting, it cannot be done.

 

[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