| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Manual Formulas
I know this can be done (I've just forgotten where the button is) but when
creating manual formulas off of the Pivot Data it always references "Get Pivot" etc. unless I manual type cell F3*XZY. There's a button that allows the data to behave "normally" so when I select the cell I want to do a formula on it will default to F3*XYZ and then I can copy and paste the data as normal in the same sheet w/ out it only referencing like the cell is locked. I hope that makes sense thanks! D |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table Manual Formulas
Check out this link...
http://www.contextures.com/xlPivot06.html -- HTH... Jim Thomlinson "Darin" wrote: I know this can be done (I've just forgotten where the button is) but when creating manual formulas off of the Pivot Data it always references "Get Pivot" etc. unless I manual type cell F3*XZY. There's a button that allows the data to behave "normally" so when I select the cell I want to do a formula on it will default to F3*XYZ and then I can copy and paste the data as normal in the same sheet w/ out it only referencing like the cell is locked. I hope that makes sense thanks! D |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| User form to change manual field filter in pivot table | Excel Discussion (Misc queries) | |||
| Formulas within a pivot table | Excel Discussion (Misc queries) | |||
| Formulas within a pivot table | Excel Discussion (Misc queries) | |||
| pivot table formulas | Excel Discussion (Misc queries) | |||
| formulas in pivot table | Excel Worksheet Functions | |||
Linear Mode
