Calculating from a pivot table
 

I am trying to do a calculation outside of a pivot table using pivot table
data. The problem is that if I reference data inside the table the cell
references the calculation as through I was using an absolute cell reference
when I want a relative cell reference. How can I turn this off at the
worksheet level?

Calculating from a pivot table
 

I don't think that's possible, but if you manually type in the cell
reference. If you just click on the cell in the pivot data it will read it as
an absolute reference. So type

=A1, instead of = and click on A1

"Joe" wrote:

I am trying to do a calculation outside of a pivot table using pivot table
data. The problem is that if I reference data inside the table the cell
references the calculation as through I was using an absolute cell reference
when I want a relative cell reference. How can I turn this off at the
worksheet level?