absolute reference while copying data from the pivot table

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table with Data Model Connection - getpivotdata reference issue 0
Pivot Table with Data Model Connection - getpivotdata #REF error 0
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Copy and paste absolute reference 3
Absolute Cell References 3
"Relative" Absolute Cell References in Excel 2007 4
SUM & OFFSET & PIVOT TABLE?? 0
Is there a way to copy cells with absolute reference gettingadjusted? 3

Top