View Single Post
  #1   Report Post  
Doit
 
Posts: n/a
Default How can I remove cell reference when calculating outside of the pi

When I attempt to calculate outside of the pivot table using a cell in the
pivot table, my formula repeats using the cell reference instead of the cell
location. I want to use cell location only.
I am using Excel 2003 & Windows XP Professional