title: Excel VBA Slow Opening
body: <p>We have an excel workbook (xlsm) which has an embedded VBA code, which looks up the distance between two points using the getgoogledistance module. </p>
  
  <p>Since we have added this to the workbook, it take a very long time to open sometimes in excess of 10 minutes.. </p>
  
  <p>I suspect on opening the workbook, it is trying to update all of the entries, hence why it is slow to open. </p>
  
  <p>Is there a way in which I could add a button to the worksheet and rather than on 'open' update the necessary cells, when this button is clicked it updated all the cells? </p>