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

October 2013.


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