title: Excel Formula Not Updating Cell
body: <p>I am using apache POI to change cells in an excel sheet. After I change the values, the cells with formulas corresponding to cells that have been changed are not updating. </p>
  
  <p>When I go into excel and click on the cell with the formula, and then click in the function bar, the formula updates.</p>
  
  <p>I have calculation options set to automatically update.</p>
  
  <p>Quick example.</p>
  
  <p>Row :</p>
  
  <p>[A2 + A3] [1] [2] </p>
  
  <p>A1 here would equal 3</p>
  
  <p>When I change it using POI:</p>
  
  <p>[A2+A3] [2] [5]</p>
  
  <p>A1 still equals 3 until I click on that cell. </p>
  
  <p>Refreshing the workbook or sheet also does not work. Is this a problem with excel or POI? Can anyone think of a workaround?</p>