title: Excel option to calculate values for each cell only once
body: <p>I have a project whose requirements include a circular reference (just so you know why I'm deliberately putting this in my workbook). </p>
  
  <p>Within the doc, I'd like for each cell in the circle to calculate only once. I know this is possible through the Windows Button > Excel Options > Formulas > Enable Iterative Calculations, but I have no way to enforce that option on everyone who touches the workbook. Is there any way (through VBA, maybe, or cell/sheet options?) to make a cell calculate its value only once?</p>
  
  <p>Sounds like a longshot to me, but I really really appreciate your help :)</p>