| 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. |
| 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) | |||
Threaded Mode
