title: Excel VBA - worksheet.calculate doesn't calculate all of my formulas
body: <pre><code>Private Sub Worksheet_Activate()
  
      If Worksheets("Input").Range("S5").Value = "Yes" Then
         MsgBox "Please make sure you've completed the historical deductible amounts for EL"
      End If
  
      Worksheets("Input").Calculate
      Worksheets("EL").Calculate
      Worksheets("PPL").Calculate
      Worksheets("Auto").Calculate
      Worksheets("AL").Calculate
      Worksheets("APD").Calculate
      Worksheets("Loss Layering").Calculate
      Worksheets("Sheet2").Calculate
      Worksheets("Premium").Calculate
  
  End Sub
  </code></pre>
  
  <p>In an effort to speed up a very large workbook I have switched off auto calculate and have created a hierarchy in which I calculate sheets as I move through my workbook. My issue is that with any heavy duty formulas such as <strong>sumif</strong> or <strong>sumproduct</strong>, the values are not calculated within my active sheet, they stay as zeroes. I have tried application.calculate and <strong>CalculateFull</strong>, these both work but I find they take up way too much time. I'm trying to find a way to do this while keeping my template as quick, simple and user friendly as possible. Any suggestions?</p>