title: Excel VBA Worksheet_Change Problem Not Calculating
body: <p>I apologise if this is a simple question but I can't seem to work it out.</p>
  
  <p>I have a spreadsheet which has cells returning values from external links. I then have cells/formulas pointing to this data running calculations. What I need to happen is to "log" (write cells values) to other cells when certain criteria are met, so I can go back and review the raw data that was there at the time. I have a cell (P3) using an IF function to return "1" when all criteria are met (i.e. when 1 appears in P3 I need the cell values copied). </p>
  
  <p>This is as far as I have got:</p>
  
  <pre><code>Private Sub Worksheet_Calculate()
        If Range("P3").Value = 1 Then
        Range("AL9").Value = Range("AJ9").Value
        Range("AL11").Value = Range("AJ11").Value
        Range("AL13").Value = Range("AJ13").Value
        Range("AL15").Value = Range("AJ15").Value
        Range("AL17").Value = Range("AJ17").Value
        Range("AL19").Value = Range("AJ19").Value
        Range("AL21").Value = Range("AJ21").Value
        Range("AL23").Value = Range("AJ23").Value
        End If
  
  End Sub
  </code></pre>
  
  <p>I originally tried with Worksheet_Change but it only works when P3 is manually updated, and doesn't work when using a formula.</p>
  
  <p>When testing in the sheet with the external data, once 1 appears in P3, all formula cells stop calculating... almost like the sheet is half frozen. The external data cells still update as per usual.</p>
  
  <p>Can anyone please point me in the right direction.</p>
  
  <p>Thanks</p>