Excel's Stale Value Formatting Arrives on More Windows PCs

Excel manual calculation mode allows you to change the spreadsheet without triggering any other calculations, but this can cause accuracy issues. The new stale value formatting feature in Excel solves this problem.

Manual calculations are useful in some cases - for example, if you have many volatile functions, if they compute simultaneously, it may cause a spreadsheet to crash - but if the changes you make in manual mode affect the current If there is a calculation, it may cause incorrect values ​​(also called stale values). Previously, it was impossible to know if the calculation was correct or stale. In fact, you have to update all the calculations in the spreadsheet, which can cause the same performance issues mentioned above.

Last August, we reported that Microsoft introduced the stale value formatting feature for Microsoft Insiders, which adds strikethrough for any stale values. Additionally, selecting a cell with stale values ​​will generate a context menu that enables Insiders to update the calculation or switch to automatic calculation mode.

This feature is now extended to users using Excel 365 for Windows (version 2409 (build 18025.20126 or later). If you meet these criteria but don't have this feature yet, you expect it to be available online in the coming weeks. Microsoft said: "The features will be released over a period of time to ensure everything works smoothly."

Although it is convenient, the format of the stale value cannot be changed. For example, you can't tell Excel to fill stale cells with yellow. So you still need to pay close attention when working with large spreadsheets, as the strikethrough text may be confused with Excel's horizontal grid lines.

Microsoft has not confirmed when (or whether) the stale cell formatting feature will be promoted to users using the web version of Excel. Paid Excel desktop apps have more advanced features than their free browser versions, so there is no guarantee that users using the online version of Excel will soon be able to use this utility.

The above is the detailed content of Excel's Stale Value Formatting Arrives on More Windows PCs. For more information, please follow other related articles on the PHP Chinese website!