| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table formula cell copy
I create a pivot table and then add a couple of columns for formula based
cells. Since upgrading to Excel 2003, the formulas do not copy with relative cell references as I have done in previous versions. Can anyone help me on this? Thanks -- Rgmacdee |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table formula cell copy
Hi
Take a look at the GetPivotData function. You'll find help for this on Debra Dalgleish's site http://www.contextures.com/xlPivot06.html -- Regards Roger Govier "Rgmacdee" wrote in message ... I create a pivot table and then add a couple of columns for formula based cells. Since upgrading to Excel 2003, the formulas do not copy with relative cell references as I have done in previous versions. Can anyone help me on this? Thanks -- Rgmacdee |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
| How do I link a cell outside a pivot table to one inside the table | Excel Discussion (Misc queries) | |||
| Cell detail in pivot table | Excel Discussion (Misc queries) | |||
| Excel 2003 Pivot Table as a source cell - | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Linear Mode
