Calculation Issues

How to Fix Excel Cells Displaying Unexpected Picture or Formatting Results

John WilsonJohn Wilson Nov 10, 2026 870 views

Question details

Users are experiencing unexpected visual formatting in cells, such as strikethroughs or picture-like artifacts, instead of the correct calculated values.

How to Fix Excel Cells Displaying Unexpected Formatting Results
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.
Before you start

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.

Solution 1Recommended

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.

1
Force Workbook Recalculation

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.

2
Access Excel Options

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'.

3
Navigate to Advanced Settings

In the Excel Options dialog box, select 'Advanced' from the left-hand menu pane.

4
Disable Stale Value Formatting

Scroll down to the 'When calculating this workbook' section. Uncheck the box labeled 'Format stale values', then click 'OK' to apply the changes.

Disable Stale Value Formatting and Force Recalculation
Tip: Switching your calculation settings back to 'Automatic' (Formulas > Calculation Options > Automatic) will also resolve this issue, as cells will never become stale.
Manage Calculation Settings Seamlessly

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. 1. Open your workbook in WPS: Launch WPS Spreadsheet and open your existing .xlsx or .xls file.
  2. 2. Access Calculation Options: Navigate to the 'Formulas' tab located on the top ribbon.
  3. 3. Set Calculation Mode: Click on 'Calculation Options' and choose 'Automatic' to ensure cells update immediately without showing stale values.
  4. 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.
Easily manage manual and automatic calculations without confusing strikethrough artifacts.Fully compatible with Microsoft Excel formats including .xlsx, .xls, and .csv.Lightweight application that handles large workbooks and complex formulas smoothly.Free to download and use with a highly familiar ribbon interface.
microsoft office alternative - wps office

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.