View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Joe Joe is offline
external usenet poster
 
Posts: 476
Default 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?