Stale Value Formatting in Microsoft Excel

I recall at my previous job, colleagues from the Product Development department often struggled with automatic calculations. Although switching to manual calculations saved time, it introduced new challenges as they couldn’t always tell which cells were updated. The new Stale Value Formatting feature in Excel would have been incredibly useful by clearly marking stale cells and ensuring data accuracy without the guesswork. It is aimed to overcome the common difficulty of identifying cells that require recalculation. When the data in a cell changes but hasn't been updated, this feature applies a strikethrough, making it simple to see which values are outdated. This addition is especially beneficial for those working with large, complex spreadsheets or multiple interlinked sheets. It ensures you always have accurate, up-to-date data without the uncertainty. This update highlights outdated cells by crossing them out. This helps you understand that you shouldn't depend on them until they are recalculated.

By default, Stale Value Formatting is turned on. If you wish to turn it off, simply uncheck the Format Stale Values box in the Calculation Options section on the Formulas tab.

Stale Formatting is currently available to users running Beta Channel on Windows. This feature will roll out to Excel for Windows first and come to the other platforms at a later date.