title: How to set calculation mode to manual when opening an excel file?
body: <p>My excel file contains a lot of formulas and I therefore want it to set calculation mode to manual as soon as it is opened. Otherwise calculation starts automatically and I have to wait for hours. I found this page:</p>
  
  <p><a href="http://excel.tips.net/T001988_Forcing_Manual_Calculation_For_a_Workbook.html" rel="nofollow noreferrer">http://excel.tips.net/T001988_Forcing_Manual_Calculation_For_a_Workbook.html</a></p>
  
  <p>which should be able to do the trick. However it's not working for my excel-file. It states that in the VBA-code, in the section "ThisWorkbook", the following code should be entered:</p>
  
  <pre><code>Private Sub Workbook_Open()
      Application.Calculation = xlManual
      Application.CalculateBeforeSave = False
  End Sub
  </code></pre>
  
  <p>As pointed it out, it doesn't work in my case. Does someone have an alternative solution?</p>