title: Turn On Automatic Calculations
body: <p>I am using Excel 2013 and we are coming across random Excel files set to manual calculations and they do not seem to go away after resetting to automatic.</p>
  
  <p>Those files seem to stay as automatic, but on a random day a different Excel file or the same Excel reverts back to manual.  I want to auto execute a macro when loading any Excel file or just the program to set Excel to automatic calculations.</p>
  
  <p>I tried the following macro:</p>
  
  <pre><code>Private Sub Auto_Open()
  Application.Calculation = xlCalculationAutomatic
  </code></pre>
  
  <p>I received the following error message upon loading Excel:</p>
  
  <blockquote>
    <p>"Run-time error '1004':  Method  'Calculation' of object'_Application'failed</p>
  </blockquote>
  
  <p>Troubleshoot:
  An Auto_Open macro runs before any other workbooks open. Therefore, if you record actions that you want Excel to perform on the default Book1 workbook or on a workbook that is loaded from the XLStart folder, the Auto_Open macro will fail when you restart Excel, because the macro runs before the default and startup workbooks open.</p>
  
  <p>If you encounter these limitations, instead of recording an Auto_Open macro, you must create a VBA procedure for the Open event as described in the next section of this article.</p>
  
  <p>Question:  is there a way to create a macro to reset any Excel file back to Automatic?  I stored the macro in my personal workbook as I am hoping that the macro will execute on any Excel file I load.</p>