When you better modify an Excel spreadsheet without triggering any new calculations, you turn onmanual calculation mode.
To solve this problem, the latest Windows Beta build adds new “stale value formatting” to Excel.
Additionally, a small warning box will appear when you click a cell with a stale value.
Microsoft
Stale value formatting will also apply to automatic calculation mode, but only in special circumstances.
Still, the feature is most helpful when in manual calculation mode.
To be clear, Excel always tracked stale values.
But users had no way of checking which cells were stale, or how many.
Unfortunately, there doesn’t appear to be a way to customize stale value formatting.
you’ve got the option to’t tell Excel to highlight stale cells in red, for example.
Stale value formatting is currently limited to Excel’s Beta Channel on Windows.
Microsoft hasn’t confirmed a timeline for when we can expect the feature on the macOS and web apps.
