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


Elaine wrote:
I create the getpivotdata outside the report and when I copy the formula, the
cell reference in the getpivotdata function is not relative.

How do I copy the getpivotdata function with the relative cell reference?


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