OLE: How to be sure Excel recalculates your cells after you did things to them

---

Situation

If you edit cells in VBA/OLE, you might want to have the whole workbook recalculated, so that you can extract data from it. This is especially true if your cells include cross-sheet formulas.

Things to try

• 
  Worksheet.Calculate Method (Excel): http://msdn.microsoft.com/en-us/library/office/ff834658.aspx
  

  
  worksheet.Calculate
  

  
  
• 
  Workbook.ForceFullCalculation Property (Excel): http://msdn.microsoft.com/en-us/library/office/ff823189.aspx
  

  
  workbook.ForceFullCalculation = true
  

  
  
• 
  Worksheet.EnableCalculation Property (Excel): http://msdn.microsoft.com/en-us/library/office/ff841201.aspx
  
  Toggle this value to force a recalculation.
  

  
  worksheet.EnableCalculation = false
  worksheet.EnableCalculation = true
  

  
  CalculateFull Method: http://msdn.microsoft.com/en-us/library/office/aa141065(v=office.10).aspx
  CalculateFullRebuild Method: http://msdn.microsoft.com/en-us/library/office/aa612775(v=office.10).aspx
  

  
  application.CalculateFull
  application.CalculateFullRebuild
  

  
  

---