K
kim
hi!
our office upgraded to excel 2002, and found out that when
i reference a cell in the pivot table for copying and
pasting, it automatically calls for the function called
GETPIVOTDATA with absolute references. i need to copy and
paste the cell with a simple calculation throughout the
rows or columns around that table, it wouldn't copy. i had
to type in the formula for each cell.
is there an easy way to get rid of absolute reference in
this process?
our office upgraded to excel 2002, and found out that when
i reference a cell in the pivot table for copying and
pasting, it automatically calls for the function called
GETPIVOTDATA with absolute references. i need to copy and
paste the cell with a simple calculation throughout the
rows or columns around that table, it wouldn't copy. i had
to type in the formula for each cell.
is there an easy way to get rid of absolute reference in
this process?