Write, Bureaucrats, Administrators
2,725
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 16:25, 12 November 2024
, 12 Novemberno edit summary
m |
|||
| Line 2: | Line 2: | ||
[[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|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]] | ||
Microsoft | In October 2024, Microsoft released an update that can make all cells in BudgetLink and Excel have '''strikethrough'''. | ||
The purpose of this update was to highlight cells that need to be recalculated when manual calculation is enabled. However, this has the unfortunate side effect of putting '''strikethrough''' through all cells in BudgetLink. This is because BudgetLink is designed with volatile formulas; that is, where the contents of the formulas change based on external factors (the get data process). | |||
BudgetLink | |||
To disable stale values formatting and remove strikethrough from the cells, please follow the steps below. | To disable stale values formatting and remove strikethrough from the cells, please follow the steps below. | ||
== Steps == | == Steps == | ||
# In the Excel Ribbon go to the '''Formulas''' ribbon. | |||
# Click on '''Calculation Options''' drop down menu and uncheck '''Format Stale Values'''. | |||
#: ''Do not change any other values.'' | |||
== 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 \> | ||