Turn On Automatic Calculations
<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>