'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Excel Pictures Showing as UNKNOWN on Another Computer
Question details
The user needs to resolve an issue where images inserted into Excel cells fail to render and display an UNKNOWN error when the workbook is opened on a different computer.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Sharing, saving, or opening an Excel workbook that contains images embedded within cells on another device.
- Observed behavior
- Pictures inserted using the Place in Cell feature or the IMAGE function disappear or display the text UNKNOWN instead of the actual image on the recipient's computer.
Ensure that both you and the recipient have saved the workbook in the standard .xlsx format, and verify if the recipient is using an older version of Excel that might lack support for recent image functions.
Convert 'Place in Cell' Images to 'Place over Cells'
Extracting the image from the cell and floating it over the worksheet ensures broader compatibility with older or preview versions of Excel.
The 'Place in Cell' feature is relatively new and is not fully supported by older versions of Office, or certain LTSC (Long-Term Servicing Channel) and preview builds. Converting the images to float over the cells bypasses this version incompatibility.
Open your workbook on the computer where the image displays correctly and right-click the cell containing the picture.
From the context menu, select 'Picture in Cell' and then click 'Place over Cells'.
Manually adjust the picture to fit over the desired area, then save the workbook and share it with the recipient again.
Verify Recipient's Excel Version and Build
Check if the computer displaying the error is running a version of Excel that natively supports in-cell image rendering.
Embed the Picture Properly Instead of Linking
Ensure the picture is fully embedded in the file, as linked images will break and disappear if the recipient does not have access to the original source path.
Avoid Version Incompatibility with WPS Office
If Microsoft Excel version mismatches continue to cause image display errors like the UNKNOWN issue, try WPS Office. It provides robust compatibility for .xlsx files and handles worksheet images smoothly across all devices without requiring expensive software upgrades.
- 1. Download and Install: Visit the official WPS website to download the free version of WPS Office and install it on your computer.
- 2. Open your Spreadsheet: Launch WPS Spreadsheets and open the .xlsx file that contains the problematic images.
- 3. View and Share: Enjoy seamless image rendering. You can easily share the file from WPS Office knowing the formatting will remain intact.
Frequently Asked Questions
Why does the Excel IMAGE function show #BLOCKED! or UNKNOWN?
This usually happens if the linked image URL is inaccessible, blocked by the recipient's firewall or privacy settings, or if their version of Excel does not fully support dynamic array image formulas.
Does 'Place over Cells' have better compatibility than 'Place in Cell'?
Yes. Inserting pictures over cells is a legacy feature supported by all versions of Excel and most alternative spreadsheet programs, whereas 'Place in Cell' is a newer feature that may fail on older versions or specific LTSC releases.
Can I recover the UNKNOWN image on the recipient's computer?
If the file was saved on a version that supports in-cell images and sent to an unsupported version, the image data is usually still preserved in the file structure. Opening the exact same file in a supported version of Excel (or a compatible alternative like WPS Office) should display the image again.
