| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Change GETPIVOTDATA cell reference to A1 style
When I use cells from a pivot table for a formula outside of the pivot table,
the cell reference is locked to this: +GETPIVOTDATA("Units",$A$3,)+GETPIVOTDATA("Units", $A$3,"YYYY","2003"). I can not find out how to turn this off so the cells are referred to by their A1 style location. Can anyone tell me how to change Excel settings so I no longer see GETPIVOTDATA in my formulas? Thanks in advance |
|
#2
|
|||
|
|||
|
Hi
Full instructions here http://www.contextures.com/xlPivot06.html Regards Roger Govier Doit wrote: When I use cells from a pivot table for a formula outside of the pivot table, the cell reference is locked to this: +GETPIVOTDATA("Units",$A$3,)+GETPIVOTDATA("Units" ,$A$3,"YYYY","2003"). I can not find out how to turn this off so the cells are referred to by their A1 style location. Can anyone tell me how to change Excel settings so I no longer see GETPIVOTDATA in my formulas? Thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I convert text string into a cell reference | Excel Discussion (Misc queries) | |||
| how do I format a cell reference to move as source changes | Excel Worksheet Functions | |||
| conditional cell shading when a change occurs | Excel Discussion (Misc queries) | |||
| How do I change a cell from absolute reference to relative referen | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
