title: Excel - Stop Calculation on Opening to prevent circular reference
body: <p>I have a large spreadsheet with a lot of built-in circular references.  I have built in VBA code to set to manual and iterative calculation on opening and also code to force a calculation on workbook open after I set to iterative calculation.  However, it appears that the workbook tries to calculate before even running this VBA code on opening, such that if the workbook is already set to automatic calculation with no iterative calculation, it runs the workbook and then crashes because of the circular references.</p>
  
  <p>I know I can set my own Application settings to always have iterative calculation, but this workbook is shared with others who may not have those same Application settings.  Is there a way to halt the calculation on opening until the code has set the application to iterative calculation.</p>
  
  <p>Thanks.</p>