title: Have to click formula bar and hit enter before it recalculates
body: <p>I have 2 worksheets.</p>
  
  <p>Worksheet 1: Nicely put up data with rows like this</p>
  
  <ul>
  <li>Row1: 5 &lt;-- This data comes from sheet 2</li>
  <li>Row2: 4 &lt;-- This data comes from sheet 2</li>
  <li>Row3: 2 &lt;-- This data comes from sheet 2</li>
  <li>Row4: =(Row1+Row2+Row3)/3 &lt;-- Simple calculation from above cells.</li>
  </ul>
  
  <p>I have this macro</p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
  
      If IsError(Cells(139, 8).Value) Then
      Call Sheet1.HideCharts
      End If
  
  End Sub
  </code></pre>
  
  <p>This works perfectly, and runs when an error occured, so if i put =5/0 (which gives an error) in row 1, the HideCharts macro runs.</p>
  
  <p>However.
  The data comes from worksheet 2, and this data comes from cubes (database) and when that data changes to i.e. nothing, it will give #REF! on worksheet 1. which i understand is an error, however then the macro won't run. What am i doing wrong? I hope you understand my question.</p>
  
  <ul>
  <li>Edit: I found out that the macro actually semi-runs. It goes through however i have to double-click the cell and just press enter, and then it activates.</li>
  </ul>