title: Excel.Worksheet.Cells[row,col] = "=Formula" vs. Range.set_Value(Missing.Value, arrayFormulas)
body: <pre><code>Excel.Worksheet.Cells[row,col] = "=Formula / reference" 
  </code></pre>
  
  <p>While in the above Excel updates the formula / reference and shows the result in the datasheet, in the code below, when using <code>Range.set_Value(..)</code> the datasheet is not updated at all</p>
  
  <pre><code>string[,] myFormulas = new string[nrRows, nrColumns];
  ...
  myFormulas [x,y] = e.g. "=SUM(D1:D" + rowNr + ")";
  myFormulas [x,y+1] = e.g. "=Table1!A1";
  ...
  Range.set_Value(Missing.Value, myFormulas)
  </code></pre>
  
  <p>and it only shows the formula as a string, e.g. <code>=Table1!A1</code>.</p>
  
  <p>I cannot make it update. Neither with <code>CalucalteAll()</code>, nor with <code>RefreshAll()</code>, nor with anyhing. Any suggestions how to achieve an update in the datasheet?</p>
  
  <p>EDIT : You can set an entire array with a single statement <code>Range.set_Value(Missing.Value, myFormulas)</code>. My question is how to make excel evaluate the formulas in this array (and not treat them as simple strings, or setting the cells one by one which Excel than recalculates.)?</p>