| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| GETPIVOTDATA with an Array | Excel Worksheet Functions | |||
| GetPivotData function returning N/A error for some rows | Excel Discussion (Misc queries) | |||
| GETPIVOTDATA Bug | Excel Worksheet Functions | |||
| "Best Practices" Use of GetPivotData Function | Excel Worksheet Functions | |||
| Copy GetPivotData Outside Report | Excel Worksheet Functions | |||
Linear Mode
