'%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)
Fix Pictures Becoming #VALUE! Errors After Reopening Excel Files
Question details
Images inserted into Excel cells disappear and display a #VALUE! error when the workbook is saved and reopened.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Saving and subsequently reopening an Excel workbook that contains images embedded or linked within cells.
- Observed behavior
- The inserted pictures are no longer visible and the affected cells display a #VALUE! error instead.
Before troubleshooting, make sure to create a backup copy of your Excel file to prevent any permanent data loss or file corruption during the repair process.
Verify Image Support and Re-embed the Pictures
Ensure the images are in a supported format and properly embedded locally rather than inserted as external links that can break.
Often, #VALUE! errors occur if an image was inserted using a web URL via the IMAGE function, and the link becomes inaccessible, or if the image format is unsupported upon reopening.
Ensure the pictures you intend to use are saved locally on your device in standard, supported formats such as JPG, PNG, or BMP.
Select the cells displaying the #VALUE! error and press the Delete key to clear the corrupted data.
Navigate to the 'Insert' tab on the ribbon, click 'Pictures', select 'This Device', and choose the local image files.
Right-click the inserted image, select 'Format Picture', go to 'Size & Properties', and choose 'Move and size with cells' to lock it properly into the cell structure.
Update Excel and Test on a Different Device
Rule out software bugs or device-specific compatibility issues by testing the file in the newest version of Excel or on another computer.
Safely Insert Pictures into Cells using WPS Spreadsheet
If Excel continues to corrupt your inserted pictures, use WPS Spreadsheet. It offers a dedicated feature to embed pictures directly into cells, ensuring they save properly and remain highly compatible without turning into #VALUE! errors.
- 1. Open your file in WPS Spreadsheet: Launch WPS Office and open your .xlsx workbook.
- 2. Select the target cell: Click on the specific cell where you want the picture to appear.
- 3. Insert picture to cell: Go to the 'Insert' tab, click the 'Picture' dropdown, and choose 'Embed to Cell'.
- 4. Select your image: Choose the image from your computer and click 'Open'. The image will automatically adapt to the cell size and save securely.
Frequently Asked Questions
Why does my Excel cell show a #VALUE! error instead of a picture?
This usually happens when an image is inserted using the IMAGE function with an invalid or inaccessible URL, or if a linked image's source file was moved, deleted, or blocked by security settings.
Can I recover the pictures that turned into #VALUE! errors?
If the pictures were linked and the source is lost or the URLs are dead, you cannot recover them directly from the corrupted file. You will need to restore the file from a previous backup or manually re-insert the images from your local drive.
How do I ensure pictures stay in Excel cells after saving?
Instead of linking to external images, insert them directly from your computer using 'Insert' > 'Pictures' > 'This Device'. Afterwards, right-click the image, select 'Format Picture', and under 'Properties', choose 'Move and size with cells'.
Does this error happen in older versions of Excel?
Yes, compatibility issues can cause this. The newly introduced IMAGE function is not supported in older versions of Excel. Opening a modern workbook in an older version will cause the unsupported image formulas to display a #VALUE! error.
