Guides
=DISPIMG in Excel: How to Show Images from WPS Spreadsheets
Updated 2026-10-13
A spreadsheet made in WPS Office has product photos or headshots in its cells. Open it in Microsoft Excel and the pictures are gone: each cell shows =DISPIMG("ID_…",1) or a #NAME? error.
Why this happens
WPS has its own way of putting images inside cells: the pictures are stored in a separate part of the file and each cell references one with a DISPIMG function. Excel has no DISPIMG function and doesn't read the part where WPS keeps the pictures, so it can only show the formula text or #NAME?.
The images are still in the file. Excel just doesn't know how to display them.
Fix 1: switch to floating pictures in WPS
If you have WPS Office:
- Open the file in WPS and select the cells with pictures (several at once is fine).
- Right-click and choose the option to switch them to floating pictures.
- Save, then open the file in Excel.
Excel displays floating pictures normally. The downside is that they no longer sit inside cells: with many pictures you often have to fix positions and sizes by hand, and they don't necessarily follow their rows when you sort or filter.
Fix 2: no WPS, or too many pictures: convert them online
xlszip's WPS image converter replaces every DISPIMG cell with a regular picture Excel can show:
- each picture is anchored in its original cell, scaled to fit and centered;
- it moves and resizes with the cell and follows its row when you sort or filter;
- only the
DISPIMG cells are cleared; every other cell and format stays the same;
- you can pick several files and download them as a zip.
The converted file shows its pictures in both Excel and WPS.
Fix 3: you just need the images
If what you need is the image files, for example to save every product photo, use Export images. WPS in-cell images are included, named by sheet and cell or by the code or name in the same row, and exported as the original files without recompression.
Avoid it next time
If the file is going to people who use Excel, insert pictures as floating pictures rather than in-cell images in WPS, or convert the file before sending it.