Home |
Search |
Today's Posts |
#1
|
|||
|
|||
GETPIVOTDATA function
The GETPIVOTDATA function used to populate automatically when I entered = and
click into my pivot data range. I have turned this auto functionality off somehow. How do I re-enable? The function I am speaking of is describe in the help section as follows: You can quickly enter a simple GETPIVOTDATA formula by typing = in the cell you want to return the value to and then clicking the cell in the PivotTable report that contains the data you want to return. |
#2
|
|||
|
|||
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 SRiley wrote: The GETPIVOTDATA function used to populate automatically when I entered = and click into my pivot data range. I have turned this auto functionality off somehow. How do I re-enable? The function I am speaking of is describe in the help section as follows: You can quickly enter a simple GETPIVOTDATA formula by typing = in the cell you want to return the value to and then clicking the cell in the PivotTable report that contains the data you want to return. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Woo Hoo! Thanks!!!!!
"Debra Dalgleish" wrote: 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 SRiley wrote: The GETPIVOTDATA function used to populate automatically when I entered = and click into my pivot data range. I have turned this auto functionality off somehow. How do I re-enable? The function I am speaking of is describe in the help section as follows: You can quickly enter a simple GETPIVOTDATA formula by typing = in the cell you want to return the value to and then clicking the cell in the PivotTable report that contains the data you want to return. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to list unique values | Excel Worksheet Functions | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
Find a Function to use accross different worksheets | Excel Worksheet Functions | |||
change function variable prompts?? | Excel Worksheet Functions | |||
Counting Function Dilemma | Excel Worksheet Functions |