Write, Bureaucrats, Administrators
89
edits
Difference between revisions of "How to remove strikethrough from cells in BudgetLink"
How to remove strikethrough from cells in BudgetLink (view source)
Revision as of 18:42, 12 November 2024
, 12 Novemberno edit summary
m |
|||
| Line 3: | Line 3: | ||
[[File:disable_stale_value_formatting.png|350px|right|thumb|select Manual calculation and uncheck Format Stale Values]] | [[File:disable_stale_value_formatting.png|350px|right|thumb|select Manual calculation and uncheck Format Stale Values]] | ||
In October 2024, Microsoft released | In October 2024, Microsoft released a '''Format Stale Values''' feature for Excel that impacts BudgetLink, rendering the text in the cells with a '''strikethrough'''. | ||
The purpose of this update was to highlight cells that need to be recalculated when manual calculation is enabled. | The purpose of this update was to highlight cells that need to be recalculated when manual calculation is enabled. These are known as '''Stale Values'''. | ||
To disable | However, this setting has the side effect of putting '''strikethrough''' through '''all''' cells in BudgetLink. | ||
This is because BudgetLink is designed using formulas with dynamic values; where the contents of the formulas change based on external factors (the '''''Get Data''''' process). | |||
'''Format Stale Values''' feature is enabled by default. | |||
To disable Stale Values Formatting and remove strikethrough from the cells, please follow the steps below. | |||
== Steps == | == Steps == | ||
| Line 13: | 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'''. | ||
#: ''Do not change any other options.'' | #: ''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 \> | ||