Excel Error Codes

Fix Excel Photo Cells Showing #VALUE! Error After Reopening

WPS Editor Sep 25, 2026 884 views

Question details

The user is experiencing a #VALUE! error in spreadsheet cells where JPG images were previously inserted successfully. The error appears only after the workbook is saved, closed, and reopened.

Fix Excel Photo Cells Showing #VALUE! Error After Reopening

Product: Microsoft Excel
Device & OS: not provided
Scenario: Saving and reopening an Excel workbook that contains images embedded directly into cells.
Observed behavior: The inserted images disappear upon reopening the file, and the affected cells display a #VALUE! error instead of the pictures.

Before you start

Before troubleshooting, create a backup copy of your current workbook to prevent any accidental data loss, and verify that your spreadsheet software is updated to the latest version to rule out known image-rendering bugs.

Solution 1Recommended

Verify Image Insertion and Formula Methods

Ensure images are properly embedded in the workbook rather than linked to an external path or an inaccessible URL that fails to load upon reopening.

The #VALUE! error often occurs when images are inserted using the IMAGE function with a URL that requires authentication, or when an external link to a local file breaks.

Check the IMAGE function URL

If you used the formula =IMAGE("URL"), ensure the URL points directly to a supported image format (like JPG) and is publicly accessible without requiring a login.

Use the Place in Cell feature

Instead of formulas, navigate to the Insert tab, select Pictures, and choose 'Place in Cell' (if available in your version) to securely embed the local JPG file.

Save as the correct format

Go to File > Save As and ensure the document is saved in the modern .xlsx format, as older formats (.xls) may not support native cell images and can convert them to errors.

Verify Image Insertion and Formula Methods

Internet Connection: If you are using the IMAGE function, the #VALUE! error will temporarily appear if your computer is disconnected from the internet when the file is reopened.

Solution 2

Isolate the Issue with a Test Workbook

Create a sanitized test file to determine if the issue is specific to the workbook's formatting, file corruption, or an application version glitch.

Seamlessly Insert Pictures into Cells with WPS Spreadsheet

Avoid annoying #VALUE! errors and broken image links by using WPS Office. WPS Spreadsheet offers a built-in, highly stable feature to embed pictures directly into cells, ensuring your images stay exactly where you put them even after saving and reopening the file.

1. Open your workbook: Launch WPS Spreadsheet and open the file where you want to add images.
2. Select the target cell: Click on the specific cell where the image should be placed.
3. Navigate to the Insert tab: Go to the 'Insert' tab on the top ribbon menu and click on 'Picture'.
4. Embed the image into the cell: Choose 'Insert to Cell' from the dropdown, browse your computer for the JPG file, and select it.
5. Save your document: Save your file normally. WPS Spreadsheet securely embeds the file into the cell data, preventing missing images or #VALUE! errors upon reopening.

Native 'Insert Picture to Cell' feature that avoids complex formula errorsFully compatible with Microsoft Excel .xlsx formatsLightweight, fast, and completely free to useStable image rendering across all your devices

Frequently Asked Questions

Why does the IMAGE function return a #VALUE! error?

The #VALUE! error typically occurs if the URL provided to the IMAGE function is broken, requires a password to view, is not a direct link to an image file, or exceeds the maximum character limit for URLs.

Can saving in an older Excel format cause cell images to disappear?

Yes. Saving a modern workbook that uses newer features like 'Place in Cell' as an older .xls format can strip out unsupported elements, resulting in errors or missing images when the file is reopened.

How do I recover my pictures if they already show #VALUE!?

If the issue stems from a temporary rendering glitch or lack of internet connectivity for linked URLs, reconnecting and recalculating the sheet may fix it. If the images were lost due to format conversion, you will need to re-insert them using the standard 'Insert Picture' tool and ensure the file is saved as .xlsx.

Microsoft Office Error Codes