File Format & Compatibility

How to Fix #VALUE! Errors with In-Cell Images in Excel Workbooks

Maira Mehtab Sep 21, 2026 868 views

Question details

The user needs to share an Excel workbook containing over 150 embedded images without colleagues encountering #VALUE! errors.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Sharing an Excel workbook containing numerous images inserted directly inside cells with colleagues who use older versions of Office.
Observed behavior: Colleagues are unable to view the images and instead see #VALUE! errors in the cells where the embedded images should appear.

Before you start

Verify which version of Excel your colleagues are using, as the 'Place in Cell' image feature is typically only supported in newer Microsoft 365 versions and will break on older standalone versions.

Solution 1Recommended

Convert In-Cell Images to Float Over Cells

Change the image placement from inside the cell to floating over the cell to ensure compatibility with older Excel versions.

The 'Place in Cell' feature is exclusive to recent Microsoft 365 updates. When users on older versions, such as Excel 2019 or Excel 2021, open a workbook with in-cell images, the application cannot render the newer data type and displays a #VALUE! error instead. Moving the images to float over the grid ensures broad compatibility.

Select the In-Cell Image

Open your workbook in the newer version of Excel where the images display correctly, and click on the cell containing the embedded picture.

Extract the Image

Right-click the cell, navigate to the 'Picture in Cell' menu, and select 'Place over Cells' to extract the image.

Align the Floating Image

Hold down the 'Alt' key on your keyboard while clicking and dragging the extracted image's corners. This will snap the floating image neatly to the cell borders.

Repeat and Save

Repeat this process for all in-cell images in the workbook. Once all images are floating, save the file and share it with your colleagues.

Manual Process Limitation: Excel does not currently have a native button to bulk-convert all in-cell images to floating images at once, so this must be done manually or via a custom VBA macro.

Free Microsoft Office alternative

Use WPS Office for Seamless Spreadsheet Compatibility

Avoid version-specific errors and strict feature limitations by switching to WPS Office. WPS Spreadsheet provides a highly compatible environment for creating, editing, and sharing workbooks, ensuring your colleagues can view your data and images exactly as intended.

1. Download and Install: Visit the official WPS website, download the free installer, and complete the lightweight installation process.
2. Open Your Workbook: Launch WPS Spreadsheet and open your existing .xlsx files directly with full formatting preserved.
3. Share with Confidence: Edit and share your documents seamlessly without worrying about restrictive version compatibility errors.

Highly compatible with standard Microsoft Excel formats (.xlsx, .xls).Easily insert, manage, and arrange both floating and embedded images.Familiar user interface with zero learning curve for Excel users.Lightweight installation and completely free to use.

microsoft office alternative - wps office

Frequently Asked Questions

Why do images inside Excel cells show as #VALUE! errors?

This error occurs because placing images directly inside a cell is a feature exclusive to newer Microsoft 365 subscriptions. When the file is opened in an older version like Excel 2016, 2019, or 2021, the software does not recognize the in-cell picture data type and returns a #VALUE! error.

Can I bulk convert in-cell images to floating images in Excel?

Currently, Excel does not offer a built-in feature to bulk extract in-cell images to floating images. You will need to convert them one by one using the right-click menu, or write a custom VBA script to automate the extraction.

Is there a way to share workbooks with in-cell images without them breaking?

To ensure in-cell images do not break, all recipients must be using a fully updated version of Microsoft 365 or Excel for the Web. If that isn't possible, you should either convert the images to float over cells or export the workbook as a PDF before sharing.

How do I properly insert an image over cells initially?

Go to the 'Insert' tab on the ribbon, select 'Pictures', choose your image file, and insert it. By default, it will float over the cells. You can then resize it and hold the 'Alt' key while dragging to perfectly align it with the cell borders.

Document & File Issues