G
Guest
Need to copy(drag) a formula that references pivot table data. eg formula
calculates a percentage for each row in a pivot table output. When I type the
formula for the first time it inserts the GETPIVOTDATA function in the
formula. When I drag the formula (or copy) the GETPIVOTDATA function acts
like an absolute cell reference instead of a varible, meaning it moves to the
next row in the pivot table. So when I drag the formula it is always locked
on the orignal Pivot Table cell. Works if you enter each formual separately.
But that is a pain for numerous rows
This use to work in Excel 2000 just fine, upgraded to 2003 and it doesn't.
Doesn't make any difference on the size of the source data. Any ideas? what
am I missing.
calculates a percentage for each row in a pivot table output. When I type the
formula for the first time it inserts the GETPIVOTDATA function in the
formula. When I drag the formula (or copy) the GETPIVOTDATA function acts
like an absolute cell reference instead of a varible, meaning it moves to the
next row in the pivot table. So when I drag the formula it is always locked
on the orignal Pivot Table cell. Works if you enter each formual separately.
But that is a pain for numerous rows
This use to work in Excel 2000 just fine, upgraded to 2003 and it doesn't.
Doesn't make any difference on the size of the source data. Any ideas? what
am I missing.