After a data connection update, some UDF’s were not executing. Using a subroutine, I was trying to recalcuate a single column with:
But above statement had no effect. None of above solutions helped, except kambeeks suggestion to replace formulas worked and was fast if manual recalc turned on during update. Below code solved my problem, even if not exactly responsible to OP “kluge” comment, it provided a fast/reliable solution to force recalculation of user-specified cells.
Application.Calculation = xlManual DoEvents For Each mycell In Sheets("mysheet").Range("D9:D750").Cells mycell.Formula = mycell.Formula Next DoEvents Application.Calculation = xlAutomatic
Leave an answer