'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Disable Excel Stale Values Formatting (Strikethrough)
Question details
The user needs to disable the Stale Values Formatting feature in Excel, which automatically applies strikethrough formatting to cells that have not been recalculated.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Working with data tables or when the calculation mode is set to Partial or Manual, resulting in false positives.
- Observed behavior
- Excel applies a distracting strikethrough format to cells it considers stale, creating confusing or false warnings that persist until the cells are recalculated.
Before altering these settings, confirm that your workbook's calculation mode is intentionally set to Partial or Manual, and ensure you know which data tables require manual recalculation.
Turn Off Stale Values Formatting in Excel Settings
The most direct method is to disable the feature within Excel's formatting or calculation settings. Doing this once may disable it permanently after a restart.
By default, Excel introduces this feature to warn you that certain cells need attention. However, it can often trigger false positives when using Partial calculation. Disabling it clears the strikethrough effect.
Click on 'File' in the top ribbon and select 'Options' to open the Excel Options dialog box.
Navigate to the Calculation or Format settings (depending on your specific Excel version) and uncheck the 'Stale Values Formatting' option.
Close and reopen Microsoft Excel. Deselecting the option once usually forces the application to disable it by default for future sessions.
Use VBA to Disable Stale Values Formatting
If the Stale Values Formatting option is missing from your settings menu due to a version bug, you can forcefully disable it using a Visual Basic for Applications (VBA) command.
Disable Automatic Error Checking
If the stale values warnings and other automatic formula alerts are generally distracting, you can choose to turn off automatic error checking entirely.
Experience Hassle-Free Calculations with WPS Office
If Excel's constant calculation warnings and stale value bugs are disrupting your workflow, consider switching to WPS Office. It provides a highly compatible, lightweight spreadsheet environment without intrusive formatting bugs, allowing you to manage your data effortlessly.
Frequently Asked Questions
Why does Excel put a strikethrough on my numbers?
Excel applies a strikethrough format to indicate 'stale values'—cells containing formulas that have not yet been recalculated to reflect recent data changes. This commonly occurs when your calculation options are set to Partial or Manual.
Will disabling Stale Values Formatting remove the strikethrough for everyone sharing the file?
Not necessarily. Stale Values Formatting is an application-level setting. Even if you turn it off on your computer, other users opening the shared workbook may still see the strikethrough if the feature remains enabled in their own Excel settings.
What should I do if the Stale Values option is completely missing from my Excel settings?
If you cannot find the setting, it may be due to a bug in your specific Excel build. You can bypass the settings menu by pressing Alt + F11 to open the VBA editor, pressing Ctrl + G for the Immediate Window, and running the command: Application.FormatStaleValues = False.
Is it safe to disable background error checking?
Yes, it is perfectly safe as long as you prefer to review your formulas manually. However, keep in mind that disabling it means Excel will no longer flag potential formula errors or inconsistencies with green triangles in the corner of your cells.
