How to Fix Excel Cells Displaying Unexpected Picture or Formatting Results
Question details
Users are experiencing unexpected visual formatting in cells, such as strikethroughs or picture-like artifacts, instead of the correct calculated values.

- Product
- Microsoft 365 Excel
- Device & OS
- not provided
- Scenario
- Viewing or editing an Excel workbook where calculations might be set to manual, resulting in stale visuals.
- Observed behavior
- Cells display stale visual formatting, automatic strikethrough, or unexpected picture results instead of the updated calculated values.
Verify if your Excel version is Microsoft 365, as the 'stale value formatting' feature causing automatic strikethroughs is specific to newer versions of the software.
Disable Stale Value Formatting and Force Recalculation
Adjust calculation settings to prevent Excel from applying strikethrough formatting to stale values when manual calculation is active.
In Microsoft 365, when your workbook is set to Manual Calculation, Excel introduces a feature called 'Stale Value Formatting'. This feature applies a strikethrough to cells containing formulas that are out of date because a dependent cell was changed.
To clear these unexpected visual artifacts, you need to either recalculate the workbook or disable the formatting feature entirely.
Navigate to the 'Formulas' tab on the ribbon and click 'Calculate Now' (or press F9 on your keyboard). This updates all formulas and immediately removes the stale formatting.
If you want to permanently stop the strikethrough effect while keeping manual calculation, go to 'File' in the top-left corner and click on 'Options'.
In the Excel Options dialog box, select 'Advanced' from the left-hand menu pane.
Scroll down to the 'When calculating this workbook' section. Uncheck the box labeled 'Format stale values', then click 'OK' to apply the changes.

Isolate the Issue with a Clean Sample Workbook
If changing calculation settings does not fix the unexpected picture results, the workbook might have hidden objects or corrupted formatting rules.
Use WPS Spreadsheet for Reliable Cell Formatting and Calculations
WPS Office Spreadsheet provides a clean, user-friendly interface for managing complex workbook calculations without unexpected visual artifacts. You can easily switch between automatic and manual calculation modes while maintaining total control over your cell formatting.
- 1. Open your workbook in WPS: Launch WPS Spreadsheet and open your existing .xlsx or .xls file.
- 2. Access Calculation Options: Navigate to the 'Formulas' tab located on the top ribbon.
- 3. Set Calculation Mode: Click on 'Calculation Options' and choose 'Automatic' to ensure cells update immediately without showing stale values.
- 4. Use Manual Calculation Safely: If working with massive datasets, select 'Manual'. You can press F9 at any time to recalculate the workbook, enjoying a distraction-free view with no forced formatting changes.

Frequently Asked Questions
What is stale value formatting in Excel?
Stale value formatting is a feature introduced in Microsoft 365. When your workbook is set to manual calculation, Excel applies a strikethrough format to cells containing formulas that depend on other cells which have been recently modified but not yet recalculated.
Why are my Excel cells showing a strikethrough automatically?
This happens when manual calculation is turned on and stale value formatting is enabled. Changing a cell's value will strike through any dependent formula cells to visually warn you that the displayed number is outdated. Calculating the workbook will remove the strikethrough.
How do I turn on automatic calculation?
Go to the 'Formulas' tab on the ribbon, click on 'Calculation Options', and select 'Automatic' from the drop-down menu. This ensures all formulas update instantly when you change a value.
Why are pictures appearing over my cells unexpectedly?
Unexpected picture results can occur if objects or images are hidden, minimized to a zero height, or tied to specific cells that have been resized. You can select the area and use the 'Go To Special' > 'Objects' tool to locate and delete unwanted floating images.




