Fix Excel Pictures Inserted in Cells Disappearing After Reopening
Question details
Users experience a bug where pictures inserted directly into spreadsheet cells vanish or display a #UNKNOWN! error when the saved workbook is reopened in the desktop application.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Saving, closing, and reopening an Excel workbook containing cell-embedded pictures in the desktop app.
- Observed behavior
- Embedded pictures either completely disappear or return a #UNKNOWN! error value upon reopening, despite functioning correctly in web or mobile versions.
Check if the workbook displays correctly in the web or mobile version of your spreadsheet app to verify the pictures are still saved in the file data before applying updates.
Update to the Latest Microsoft 365 or Office Build
Microsoft frequently patches known bugs, including the disappearing embedded pictures issue. Updating your Office suite is the primary recommended fix.
This bug is known to affect specific builds of the desktop application. Installing the latest official release typically replaces the buggy files and restores normal functionality for embedded images.
Open Microsoft Excel, click on 'File' in the top-left corner, and select 'Account' (or 'Office Account') from the bottom of the left sidebar.
Under the 'Product Information' section, click on the 'Update Options' dropdown menu.
Select 'Update Now'. Allow the system to download and install any pending updates, then restart Excel to see if the pictures display correctly.

Insert Pictures Over Cells as a Workaround
If the bug persists in your specific Excel build, inserting the picture over the cells avoids the #UNKNOWN! error altogether.
Use WPS Office to Avoid Excel Compatibility Bugs
If you are tired of losing images due to the Excel #UNKNOWN! error and persistent build bugs, try WPS Office. It provides a highly compatible, lightweight spreadsheet tool that safely stores and displays cell-embedded pictures without the hassle.

Frequently Asked Questions
Why do my embedded pictures show as #UNKNOWN! in Excel?
This is a known bug in certain builds of the desktop spreadsheet application. While developers patch these issues in newer updates, some specific versions may still experience the parsing error when saving and reopening a workbook.
Are the disappeared pictures permanently lost from my file?
Not usually. In most cases, the image data is still intact in the file but the desktop app fails to render it. Opening the exact same workbook in the Web or Mobile app versions often displays the pictures perfectly.
What is the difference between placing a picture in a cell versus over a cell?
A picture placed 'in a cell' becomes an embedded part of the cell's data, allowing it to sort, filter, and hide alongside the row contents. A picture 'over a cell' is a floating object that sits above the spreadsheet grid and requires manual configuration to move or size with cells.
Are there alternative spreadsheet programs that safely open files with cell-embedded pictures?
Yes, alternative office suites like WPS Spreadsheet fully support the insertion and rendering of pictures into cells. Opening your existing .xlsx files in WPS avoids the specific rendering bugs tied to other application builds.




