title: Excel formulas needs to be clicked in order to get evaluated
body: <p>I've wrote an python program that basically reads excel formulas in form of `=FORMULA and write it into an output excel. Here is my code:</p>
  
  <pre><code>source=open_workbook('source.xls',formatting_info=True)
  
  wb = copy(source)
  ws = wb.get_sheet(0)
  
  funWriter = open_workbook('template.xls')
  VolProfile = funWriter.sheet_by_index(0)
  
      for row in range(VolProfile.nrows):
  -   for col in range(VolProfile.ncols):
  -        cellValue = VolProfile.cell(row,col).value
  -        try:
  -            if cellValue[0] == "`":
  -                 cellValue = cellValue[2:]
  -                 ws.write(row,col,Formula(cellValue))
  -            else:
  -                 pass
  -         except:
  -               pass
  wb.save('Final.xls')
  </code></pre>
  
  <p>the code wrties the formula successsfully, however, the excel was unable to evaluate and generate a (#VALUE!) error unless I click onto the formula bar and press enter.</p>
  
  <p>I tried to save it and press f9 and they all didnt work. 
  Any idea on how to prevent me from clicking and pressing enter for 800 times??</p>
  
  <p>Thanks!</p>