Write, Bureaucrats, Administrators
17
edits
Difference between revisions of "How to remove strikethrough from cells in ODBCLink"
How to remove strikethrough from cells in ODBCLink (view source)
Revision as of 23:12, 10 November 2024
, 10 Novemberno edit summary
(Created page with "= Overview = 350px|right|thumb|select Manual calculation and uncheck Format Stale Values Microsoft recently released '''Stale Value...") |
m |
||
| Line 5: | Line 5: | ||
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. | ||
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. | To disable stale values formatting and remove strikethrough from the cells, please follow the steps below. | ||