ExcelBanter - getpivotdata

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - getpivotdata (https://www.excelbanter.com/excel-discussion-misc-queries/103853-getpivotdata.html)

br549

getpivotdata

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

Ron Coderre

getpivotdata

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

All times are GMT +1. The time now is 09:32 PM.