title: Auto Refresh Excel Sheet
body: <p>I have an excel workbook, in the workbook I have 2 sheets called  Front Page and Drafting. Drafting worksheet is referencing some of the values in the Front Page worksheet. It is just a basic reference</p>
  
  <p>I have formulas like :  ='Front Page'!D46 (in the drafting page cells to reference the cells in the Front Page)</p>
  
  <p>My problem is whenever I make a change to one of the referenced cells on the front page, I need to refresh my drafting page in order to get the newly entered value. 
  I need to press F9 every time I make a change in the front page to make it reflect back to Drafting Page.</p>
  
  <p>I am not sure what is causing this issue? Could someone please help me fix it?</p>
  
  <p>Thank you. </p>