title: How to refresh cell values in an excel workbook automatically?
body: <p>I have an excel workbook that contains 3 worksheets.</p>
  
  <p>Worksheet 1 contains the input cell on cell A1 (i.e. a drop down list).
  Worksheet 2's cell B2 reference the information of cell A1 of worksheet 1.
  Worksheet 3's cell B3 reference the information of cell A1 of worksheet 1 too.</p>
  
  <p>However, when I change the value of cell A1 of worksheet 1, it seems like the referenced values don't change automatically - which seem strange.</p>
  
  <p>Is there any method I could use to evoke an update automatically whenever cell A1 change?</p>