Write, Bureaucrats, Administrators
89
edits
Difference between revisions of "How to remove strikethrough from cells in BudgetLink"
Jump to navigation
Jump to search
m
How to remove strikethrough from cells in BudgetLink (view source)
Revision as of 01:40, 5 November 2024
, 5 Novemberno edit summary
m |
m |
||
| Line 1: | Line 1: | ||
= Overview = | = Overview = | ||
[[File:disable_stale_value_formatting.png|350px|right|thumb|uncheck '''Format Stale Values''']] | [[File:disable_stale_value_formatting.png|350px|right|thumb|uncheck '''Format Stale Values''']] | ||
Microsoft recently released '''Stale Value Formatting''' for Excel on Windows. | Microsoft recently released '''Stale Value Formatting''' for Excel on Windows. | ||
When the underlying data in any cell changes after Get Data is complete, Excel denotes the cell as '''Stale''' since the underlying formula has not been recalculated. | When the underlying data in any cell changes after Get Data is complete, Excel denotes the cell as '''Stale''' since the underlying formula has not been recalculated. | ||
| Line 7: | Line 7: | ||
BudgetLink uses Visual Basic Scripts to perform calculations, hence the cell formula never changes, but the underlying data does. | BudgetLink uses Visual Basic Scripts to perform calculations, hence the cell formula never changes, but the underlying data does. | ||
To 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 under '''Formulas''' click on Calculation Options drop down button and Uncheck '''Format Stale Values'''. | ||
# Strikethrough will be removed from all cells. | # Strikethrough will be removed from all cells. | ||