See Debra Dalgleish's instructions:

http://www.contextures.com/xlPivot06.html

(The section on "Generate GetPivotData" explains how to add the button that
toggles the GetPivotData settings)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"br549" wrote:

How do I disable the "getpivotdata" feature? I want to use a formula that
refers to a pivot table and that I can drag & fill. I don't want Excel to
automatically insert the "getpivotdata" function