| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cancelling getpivot formula when setting formula outside pivot ta.
In the office 2003 version an automatic getpivotdata formula is created when
setting a formula outside the pivot table.this makes it impossible to copy the formula to other cells as all data becomes fixed. how can I turn to my old formula setting mode? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cancelling getpivot formula when setting formula outside pivot ta.
See Debra Dalgleish's website for GetPivotData instructions:
http://www.contextures.com/xlPivot06.html#GetPivotData Does that help? *********** Regards, Ron XL2002, WinXP "cancelling getpivot formula" wrote: In the office 2003 version an automatic getpivotdata formula is created when setting a formula outside the pivot table.this makes it impossible to copy the formula to other cells as all data becomes fixed. how can I turn to my old formula setting mode? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cancelling getpivot formula when setting formula outside pivot
In stead of selecting the cell by clicking the button of your mouse to use in
your formule, you have to type the cell number in your formula (example type =a2-b2 in stead of clicking on cell a2 & than on b2 with your mouse). Normally this should do it. "Ron Coderre" wrote: See Debra Dalgleish's website for GetPivotData instructions: http://www.contextures.com/xlPivot06.html#GetPivotData Does that help? *********** Regards, Ron XL2002, WinXP "cancelling getpivot formula" wrote: In the office 2003 version an automatic getpivotdata formula is created when setting a formula outside the pivot table.this makes it impossible to copy the formula to other cells as all data becomes fixed. how can I turn to my old formula setting mode? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom Formula in Pivot Table Row | Excel Worksheet Functions | |||
| Custom Formula in Pivot Table Row | Charts and Charting in Excel | |||
| Match then lookup | Excel Worksheet Functions | |||
| Need Formula to display pivot table source data | Excel Worksheet Functions | |||
| Setting default pivot table field setting to "sum" | Excel Discussion (Misc queries) | |||
Linear Mode
