Linking cells to Pivot Tables in Office XP "Get Pivot" frustrations

[Trevor]

I was recently upgraded to Office XP at work. I've encountered one
frustrating new feature. I can no longer link a cell to a pivot table
cell and copy this linked cell across the row. For example, in the
linked cell formula,instead of the linked cell referring to the pivot
table cell as "C11" it refers to it as
"GETPIVOTDATA("PMPM",$I$18,"Rpt_Date",DATE(2003,11,1),"renew_current",DATE(2004,1,1))".
This may return the correct value for this intial cell but if I try
to copy this link to the next cell over (across the row), I get the
same value (not the value from the pivot table one cell over). I
don't want to have to individually link each cell to the pivot table.
Is there a way I can turn this "Getpivotdata" feature off? Any other
solutions?

Thanks,

Trevor

 

[Debra Dalgleish]

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.