View source for How to remove strikethrough from cells in ODBCLink

= Overview =
[[File:disable_stale_value_formatting.png|350px|right|thumb|select Manual calculation and uncheck Format Stale Values]]
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.

ODBCLink uses Visual Basic Scripts to perform calculations, hence the cell formula never changes, but the underlying data does.

To disable stale values formatting and remove strikethrough from the cells, please follow the steps below.

== Steps ==
# In the Excel Ribbon under '''Formulas''' click on '''Calculation Options''' drop down button and select '''Manual''' calculation.
# In the '''Calculation Options''' drop down menu, uncheck '''Format Stale Values'''.
# Strikethrough will be removed from all cells.


== References ==
: [https://support.microsoft.com/en-au/office/stale-value-formatting-4b5c63c3-5dc7-4e9b-8e24-88bed1987dbd|Excel - Stale Values Formatting]
<br \>