Linking to a Pivot Table

[Bryce]

In previous versions of Excel, when I would reference a
formula to a pivot table, and copied the formula down, the
formula would change...as in a relative reference. In
Excel 2002, performing the same action results in a
formula that is absolute, and does not change when copied
down. I can bypass this by refering to the cell in the
pivot table by using =SUM formula. The formula remains
relative and can be copied. Is there another way around
this?

 

[Debra Dalgleish]

In Excel 2002, a GETPIVOTDATA formula is automatically created when you
link to a cell in a pivot table.

You can choose Tools>Customize, and from the Data category on the
Commands tab, add the Generate GetPivotData command to one of your
toolbars. Use this button to toggle the feature on and off.

Or, you can type an equal sign, and type the cell reference, instead of
clicking on the cell to reference it.