Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Is there any way to disable the "getpivotdata" automatic formula?
In Excel 2003, I notice that when I reference a cell in a Pivot Table for a
formula outside the table, Excel assumes that I want to use the GetPivotData formula. Then, I am unable to drag the formula cell, as the the values in the formula are locked. Is there any way to disable this function or change to a regular formula (such as by pressing F4 to freeze or not freeze references). I relaize that I can manually type in the reference, but this takes much longer. Thanks. |
#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 BGN wrote: In Excel 2003, I notice that when I reference a cell in a Pivot Table for a formula outside the table, Excel assumes that I want to use the GetPivotData formula. Then, I am unable to drag the formula cell, as the the values in the formula are locked. Is there any way to disable this function or change to a regular formula (such as by pressing F4 to freeze or not freeze references). I relaize that I can manually type in the reference, but this takes much longer. Thanks. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Many thanks! Works perfectly.
"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 BGN wrote: In Excel 2003, I notice that when I reference a cell in a Pivot Table for a formula outside the table, Excel assumes that I want to use the GetPivotData formula. Then, I am unable to drag the formula cell, as the the values in the formula are locked. Is there any way to disable this function or change to a regular formula (such as by pressing F4 to freeze or not freeze references). I relaize that I can manually type in the reference, but this takes much longer. Thanks. -- 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 | |||
Disable Query Refresh warning dialog box in Excel 2003 | Excel Discussion (Misc queries) | |||
How do I use turn GETPIVOTDATA function off? | Excel Worksheet Functions | |||
Copy GetPivotData Outside Report | Excel Worksheet Functions | |||
how to convert GETPIVOTDATA from excel 2000 to excel 2002... | Excel Worksheet Functions | |||
Disable Adding & Deleting Rows/Columns | Excel Discussion (Misc queries) |