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


October 2013.

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