File Corruption & Recovery

Fix Excel Picture in Cell Displaying UNKNOWN Error After Reopening

John WilsonJohn Wilson Nov 10, 2026 873 views

Question details

Images inserted directly into cells display as an UNKNOWN! error placeholder after saving and reopening the Excel workbook.

How to Fix Excel Picture in Cell Displaying UNKNOWN! After Reopening
Product
Microsoft Excel 2024
Device & OS
Windows 11
Scenario
A user is inserting JPEG or PNG images directly into spreadsheet cells using the 'This Device' option, intending to use these images in lookup formulas.
Observed behavior
The inserted images appear correctly at first, but change to UNKNOWN! once the workbook is saved and reopened. Images placed inside shapes remain visible but cannot be utilized for cell-based lookup formulas.
Before you start

Before attempting any troubleshooting steps, make a backup copy of your Excel file to ensure your original data remains safe during the repair process.

Solution 1Recommended

Update Microsoft Excel and Test the Workbook Format

Applying the latest Office updates often resolves known image-rendering bugs in Excel 2024. Resaving the file helps confirm if the format was causing the corruption.

Microsoft frequently releases patches to address specific application glitches, including issues with the newer 'Picture in Cell' feature.

1
Check for Office Updates

Open Excel, click on 'File' in the top-left corner, and select 'Account' at the bottom of the menu. Under 'Product Information', click 'Update Options' and choose 'Update Now'.

2
Restart and Open File

Once the updates are fully installed, restart your computer and open the affected Excel workbook.

3
Save a Test Copy

Go to 'File' > 'Save As', and save a new copy of the file in the standard Excel Workbook (*.xlsx) format. Reopen this new file to check if the 'UNKNOWN!' error persists.

Update Microsoft Excel and Test the Workbook Format
Try Excel for the Web: If updating doesn't immediately fix the local desktop app, try opening your workbook in Excel for the Web. Sometimes the web version bypasses local rendering bugs.
Free Microsoft Office alternative

Open and Edit Excel Files Seamlessly with WPS Office

Since the 'UNKNOWN!' picture bug is an issue tied to Microsoft Excel's internal rendering engine, switching to WPS Office can help you immediately access your files and avoid these glitches. WPS Office is free, lightweight, and highly compatible with Microsoft Office formats, allowing you to view and edit pictures in cells without the frustrating errors.

  1. 1. Download and Install: Download WPS Office for free from the official website and follow the easy installation prompts to set it up on your Windows 11 device.
  2. 2. Open Your Workbook: Launch WPS Spreadsheet, go to Menu > Open, and select your affected .xlsx file that contains the missing pictures.
  3. 3. Manage Cell Pictures: View and edit your spreadsheet normally. WPS Office securely handles images without displaying the 'UNKNOWN!' error.
Highly compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Free and lightweight, avoiding bulky installation and slow load times.Stable image rendering for pictures inserted into spreadsheets.Familiar user interface makes migration effortless.
microsoft office alternative - wps office

Frequently Asked Questions

Why do my Excel cell pictures turn into UNKNOWN!?

This is often caused by a software bug or file corruption in Excel 2024 affecting how embedded 'Picture in Cell' images are rendered and saved. Saving in older file formats or missing recent Office updates can also trigger this display error.

Does Excel for the Web show the UNKNOWN! error?

In many cases, opening the affected workbook in Excel for the Web can bypass local desktop application bugs, allowing you to see the images correctly if the file itself isn't severely corrupted.

How do I use images for lookup formulas without getting this error?

If the 'Picture in Cell' feature remains buggy on your current build, you can try inserting images into shapes or using the Camera tool linked to cells as a workaround, though these methods are more complex to integrate into standard VLOOKUP or XLOOKUP formulas.

Will using 'Open and Repair' delete my formulas?

The 'Open and Repair' feature attempts to salvage all data, including formulas. However, if a specific formula or cell is heavily corrupted, Excel might remove that element to restore the rest of the workbook. This is why keeping a backup copy is essential.