Fix Excel Picture in Cell Displaying UNKNOWN Error After Reopening
Question details
Images inserted directly into cells display as an UNKNOWN! error placeholder after saving and reopening the Excel workbook.

- 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 attempting any troubleshooting steps, make a backup copy of your Excel file to ensure your original data remains safe during the repair process.
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.
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'.
Once the updates are fully installed, restart your computer and open the affected Excel workbook.
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.

Run the Microsoft Office Repair Tool
If the UNKNOWN error happens across multiple workbooks, repairing the Office installation can fix corrupted application files causing the issue.
Use the Open and Repair Feature
If the problem is isolated to a single workbook, the file itself might be corrupted and needs internal repair to restore the embedded images.
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. 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. Open Your Workbook: Launch WPS Spreadsheet, go to Menu > Open, and select your affected .xlsx file that contains the missing pictures.
- 3. Manage Cell Pictures: View and edit your spreadsheet normally. WPS Office securely handles images without displaying the 'UNKNOWN!' error.

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.




