title: Excel c# Issue - formula not being recalculated
body: <p>I am working on a document-level excel project. This is the third version. </p>
  
  <p>One of the worksheet contains a list object (data fed from a database). Then there are cells contains formulas like the following</p>
  
  <p>this.Range["F15"].Formula = "=COUNTIFS(HotList_ListObject[Product],E15,HotList_ListObject[Got_Interest],\"&lt;>\")"</p>
  
  <p>previously, I created the table by just drag-and-drop. then simply created a formula in the worksheets. and the formulas were recalculated as data in the listobject (HotList_ListObject above). </p>
  
  <p>this time, I created the table by the code. Because Hotlist_ListObject is not on the worksheet until the application runs, I supply the formulas after creating the listobject by code. </p>
  
  <p>I looked through the internet and did a couple of testings.</p>
  
  <p>When I press F9, SHIFT+F9 and CTRL+ALT+F9, it doesn't recalculate. </p>
  
  <p>Only when I press CTRL+SHIFT+ALT+F9, it recalculates</p>
  
  <p>the explantion I found for  CTRL+SHIFT+ALT+F9 is </p>
  
  <p>Rechecks dependent formulas, and then calculates all formulas in all open workbooks, regardless of whether they have changed since last time or not.</p>
  
  <p>It seems that because the formula is supplied in the worksheet by code, it does not create links to dependent formulas or something so it won't recalculate. (something like this, I suppose)</p>
  
  <p>My users are not going to press the button every time they modify/add/delete records in the list. </p>
  
  <p>what can I do to resolve this? How to tell Excel that the formulas need to recalculate every-time any thing changes in the listobject. </p>
  
  <p>Thanks for any advice in advance!</p>
  
  <p>Kind regards 
  Mark</p>