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
1 | Selection.Value = Selection.FormulaR1C1 |
function
- u can this cell function add now function
f() + now()*0
reference
All articles in this blog are licensed under CC BY-NC-SA 4.0 unless stating additionally.
Comment