Copying formulas using Pivot Table data
 

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.
--
jhkarr

Copying formulas using Pivot Table data
 

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

jhkarr wrote:
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.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Copying formulas using Pivot Table data
 

Debra,

thanks for the tip. I have placed the button on my menu bar, but I can't see
where it is turning on or off and I have tried various test pivot tables. The
typed entry of =$B$5 solves my problem for now. I work the other item later.
Thank you very much.

"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

jhkarr wrote:
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.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html