| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I turn OFF the GETPIVOTDATA function?
I often want to reference a cell value in a pivot table by simply clicking on
the cell (rather than typing in the cell reference) usually to use in a separate formula. I could do this in previous versions of Excel. In the current version of Excel I get the GETPIVOTDATA function which includes absolute cell references which means I cannot drag the formula down. This is quite minor but also enfuriating. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conversion | Excel Worksheet Functions | |||
| Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions | |||
| GETPIVOTDATA function | Excel Worksheet Functions | |||
| Formula to list unique values | Excel Worksheet Functions | |||
| I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
Threaded Mode
