| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pivit table- cell on spread sheet referencing pivot table field
With the old version of excel you could use the mouse to do a calculation
between a cell in a pivottable and one just on a cell in the spreadsheet.- Is there a way of turning of the cell reference in Office XP etc- e.g from outside the pivot table go +a5, where A5 is a cell in the pivot. Thanks if you can help. David |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Pivit table- cell on spread sheet referencing pivot table field
There are instructions here for adding the Generate GetPivotData button
to a toolbar, and toggling the feature on and off: http://www.contextures.com/xlPivot06.html David M wrote: With the old version of excel you could use the mouse to do a calculation between a cell in a pivottable and one just on a cell in the spreadsheet.- Is there a way of turning of the cell reference in Office XP etc- e.g from outside the pivot table go +a5, where A5 is a cell in the pivot. Thanks if you can help. David -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Pivit table- cell on spread sheet referencing pivot table fiel
Great thanks for that
"Debra Dalgleish" wrote: There are instructions here for adding the Generate GetPivotData button to a toolbar, and toggling the feature on and off: http://www.contextures.com/xlPivot06.html David M wrote: With the old version of excel you could use the mouse to do a calculation between a cell in a pivottable and one just on a cell in the spreadsheet.- Is there a way of turning of the cell reference in Office XP etc- e.g from outside the pivot table go +a5, where A5 is a cell in the pivot. Thanks if you can help. David -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change a pivot table field by typing into another cell | Excel Discussion (Misc queries) | |||
| Excel Pivot Table link page field to spreadsheet cell | Excel Discussion (Misc queries) | |||
| Pivot Table: Remove old field cell value | Excel Discussion (Misc queries) | |||
| Pivot Table Page field link to cell | Excel Worksheet Functions | |||
| pivit table will not caculate | Excel Discussion (Misc queries) | |||
Linear Mode
