How to fix excel formula auto-calculate

Story

Excel third-party addin help us to solve complicated numeric problem.Sometimes all cells refresh by add-in but some cells need to using f2 + Enter to enforce it refresh.This article tell u two way to solve it.

solution

vba

Selection.Value = Selection.FormulaR1C1

function

• u can this cell function add now function

f() + now()*0

---

reference

• Force “F2”+“Enter” on range of cells - stackoverflow Thomas F.
• How to Fix Excel Formulas that are Not Calculating or Updating - EXCEL Campus