Function Problems

How to Fix Excel IMAGE Function Missing or #NAME? Error

Steve K Oct 9, 2026 869 views

Question details

The user is encountering a #NAME? error or cannot find the IMAGE function when attempting to use it in Excel.

How to Fix Excel IMAGE Function Missing or #NAME? Error

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to insert pictures into spreadsheet cells using the IMAGE formula.
Observed behavior: The IMAGE function is completely missing from the function library, or it returns a #NAME? error when typed manually, indicating an unsupported product version.

Before you start

Verify your Microsoft Office account details and save your current workbook to a safe location before checking for updates or switching to a web-based platform.

Solution 1Recommended

Check Your Office Version and Update Microsoft 365

Use this solution to verify if your current Excel version supports the IMAGE function and update it if you are a Microsoft 365 subscriber.

The IMAGE function is a newer feature that is only supported in Microsoft 365 and newer release versions. It is not available in standalone older versions like Office 2019.

If you have a Microsoft 365 subscription but still see the #NAME? error, you may need to install the latest updates or check your update channel.

Open Account Settings

Launch Microsoft Excel, click on 'File' in the top-left corner, and select 'Account' from the bottom of the left-hand menu.

Verify Office Version

Under 'Product Information', check if your version says 'Microsoft 365'. If it says 'Office 2019' or older, the function is natively unsupported on your desktop app.

Update Excel

If you are using Microsoft 365, click on 'Update Options' next to Office Updates and select 'Update Now' to ensure you have the latest features installed.

Check Your Office Version and Update Microsoft 365

Update Channels: Enterprise users might be on a delayed update channel (like Semi-Annual Enterprise Channel) which receives new functions later. Contact your IT admin if updates are managed by your organization.

Solution 2

Use Excel for the Web

If you are on an older desktop version like Office 2019, you can still use the IMAGE function for free through Excel for the web.

Insert Pictures Directly into Cells with WPS Spreadsheet

If your current Excel version lacks the IMAGE function, WPS Spreadsheet provides a built-in feature to easily insert and lock pictures directly inside cells, completely bypassing the need for complex formulas.

1. Download and Install WPS Office: Download WPS Office from the official website and open WPS Spreadsheet.
2. Select the Target Cell: Click on the specific cell where you want to embed your image.
3. Insert Picture to Cell: Navigate to the 'Insert' tab on the top ribbon, click 'Picture', and choose 'Place in Cell'.
4. Choose Your Image: Select the image file from your computer and click 'Open'. The image will perfectly fit and lock inside the selected cell.

Insert and lock images into cells seamlessly without formula errorsFully compatible with Microsoft Excel (.xlsx) formatsFree, lightweight, and fast alternative to heavy office suites

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel show a #NAME? error when I type =IMAGE()?

The #NAME? error occurs because your version of Excel does not recognize 'IMAGE' as a valid function. This happens primarily on older versions of Office, such as Office 2019 or 2016, which do not support this newer Microsoft 365 feature.

Can I download the IMAGE function as an add-in for Office 2019?

No, native functions like IMAGE cannot be downloaded as standalone add-ins for older versions of Excel. You must upgrade to Microsoft 365, use Excel for the web, or use alternative software like WPS Office.

Does the IMAGE function work offline?

If you are referencing an image URL from the internet (e.g., =IMAGE("https://example.com/pic.jpg")), you must have an active internet connection for Excel to download and display the picture. If offline, the cell may show an error.

Are there alternative ways to insert images in older Excel versions?

Yes. In older versions, you can go to the Insert tab and select Pictures to place an image over the grid. However, it will float above the cells rather than being embedded inside a specific cell like the IMAGE function does.

Excel & Data Problems