Excel Error Codes

How to Fix Excel Pictures in Cells Showing #UNKNOWN Error

Maira Mehtab Sep 20, 2026 869 views

Question details

Users are encountering an issue where the Pictures in Cells feature stops working, displaying #UNKNOWN errors or broken formulas in desktop Excel, despite the images remaining visible in Excel Online.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Using the Pictures in Cells feature in the desktop application after a recent Microsoft Office update.
Observed behavior: Pictures inserted into cells display as #UNKNOWN, broken formulas, or ###### cross-references in the desktop app, but still appear correctly when viewed in Excel Online.

Before you start

Before attempting to roll back your Office version, verify if your organization manages your system updates, as you may need IT administrator permissions to execute update commands.

Solution 1Recommended

Roll Back to a Previous Office Version

Downgrading Office to an earlier build where the Pictures in Cells feature functioned correctly (such as version 2402.17328.20452) can resolve the #UNKNOWN error.

The Pictures in Cells feature was officially released in Office version 2402.17328.20452. If a recent update broke this functionality, reverting to an earlier, stable build is the most effective workaround until Microsoft releases a patch.

Note that if your computer is managed by an organization, the ability for individual users to disable or revert updates might be restricted.

Contact your IT Department

If your company manages your device, reach out to your IT helpdesk and request them to roll back the Office update, as user-level changes may be disabled.

Use the Click-to-Run update command

If you have administrative rights, open the Command Prompt as an administrator and use the Office Click-to-Run executable to revert to a specific stable build (e.g., version 2402.17328.20452).

Disable automatic updates temporarily

After rolling back successfully, open Excel, navigate to File > Account > Update Options, and click 'Disable Updates' to prevent the problematic version from reinstalling automatically.

Temporary Workaround: While you wait for your IT department to roll back the update, you can continue viewing and working with your images correctly by opening the affected spreadsheet in Excel Online.

Free Microsoft Office alternative

Use WPS Office for a Stable Spreadsheet Experience

If Microsoft Office updates are causing workflow interruptions and unexpected errors, consider switching to WPS Office. It provides a lightweight, highly compatible alternative for managing spreadsheets without forced update bugs disrupting your work.

1. Download and Install WPS Office: Get the free WPS Office suite from the official website and complete the quick installation process.
2. Launch WPS Spreadsheet: Open WPS Office and click on the Spreadsheet icon to start a new workspace.
3. Open Your Excel File: Navigate to Menu > Open and select your existing .xlsx file to view and edit your data flawlessly.

Highly compatible with Microsoft Excel (.xlsx) file formats.Insert, format, and manage pictures in spreadsheets seamlessly.Lightweight installation with no forced or disruptive updates.Familiar user interface ensures a smooth and quick transition.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel show #UNKNOWN for pictures in cells?

This error typically occurs due to a bug introduced in a recent Microsoft Office update, causing the desktop application to lose recognition of the newly introduced Pictures in Cells data type.

Can I fix the #UNKNOWN error without rolling back Office?

Currently, the most reliable fix is reverting to an older version. However, a temporary workaround is to view and edit the affected file using Excel Online, where the pictures still render properly.

How do I know which Office version introduced Pictures in Cells?

The Pictures in Cells feature was officially released in Office version 2402.17328.20452. You must roll back to at least this version or an immediately subsequent stable build to retain the feature without errors.

Microsoft Office Error Codes