Write, Bureaucrats, Administrators
89
edits
m |
m |
||
Line 1: | Line 1: | ||
= Overview = | = Overview = | ||
[[File:strikethrough_stale_values.png|300px|right|thumb|]] | [[File:strikethrough_stale_values.png|300px|right|thumb|]] | ||
[[File:disable_stale_value_formatting.png|350px|right|thumb| | [[File:disable_stale_value_formatting.png|350px|right|thumb|Uncheck Format Stale Values]] | ||
In October 2024, Microsoft released a '''Format Stale Values''' feature for Excel that impacts BudgetLink, rendering the text in the cells with a '''strikethrough'''. | In October 2024, Microsoft released a '''Format Stale Values''' feature for Excel that impacts BudgetLink, rendering the text in the cells with a '''strikethrough'''. | ||
Line 19: | Line 19: | ||
# In the Excel Ribbon go to the '''Formulas''' ribbon. | # In the Excel Ribbon go to the '''Formulas''' ribbon. | ||
# Click on '''Calculation Options''' drop down menu and uncheck '''Format Stale Values'''. | # Click on '''Calculation Options''' drop down menu and uncheck '''Format Stale Values'''. | ||
: ''Note: Do not change any other options.'' | |||
== References == | == References == | ||
: [https://support.microsoft.com/en-au/office/stale-value-formatting-4b5c63c3-5dc7-4e9b-8e24-88bed1987dbd|Excel - Stale Values Formatting] | : [https://support.microsoft.com/en-au/office/stale-value-formatting-4b5c63c3-5dc7-4e9b-8e24-88bed1987dbd|Excel - Stale Values Formatting] | ||
<br \> | <br \> |