Pivot Table Issues

How to Fix Excel Pivot Table Showing 'Picture' Instead of Images

Adam Davis Oct 12, 2026 870 views

Question details

The user needs a solution or workaround for when images inserted into Excel cells display only as the text "Picture" inside a Pivot Table.

How to Fix Excel Pivot Table Showing "Picture" Instead of Images

Product: Microsoft Excel
Device & OS: not provided
Scenario: Creating a Pivot Table using a source table that contains images within the cells.
Observed behavior: The Pivot Table renders the word "Picture" instead of displaying the actual image objects from the source cells.

Before you start

Before troubleshooting, ensure your Microsoft 365 subscription is fully updated, as newer updates sometimes improve how the 'Place in Cell' image feature interacts with advanced data tools.

Solution 1Recommended

Use an XLOOKUP Report Instead of a Native Pivot Table

Since native Pivot Tables often fail to render in-cell images, you can build a dynamic dashboard using lookup formulas that fully support image rendering.

Excel's Pivot Table engine currently has limitations when rendering the new 'Image in Cell' data type, frequently replacing the graphical object with placeholder text. Instead of relying on a Pivot Table, building a dynamic lookup report is the most scalable workaround.

Extract unique values

Use the UNIQUE function on your source table's primary category column to create a distinct list of items for your new report sheet.

Build the lookup formula

In the adjacent column, use the XLOOKUP or INDEX/MATCH function to reference the unique values and pull the corresponding data, including the specific cell containing the image.

Format the new report

Adjust the row heights and column widths of your new reporting sheet to ensure the pulled images display at the correct scale without distortion.

Use an XLOOKUP Report Instead of a Native Pivot Table

Avoid Manual Copying: Do not attempt to manually copy and paste thousands of floating images into the Pivot Table area. This will drastically bloat the file size, and the images will not update dynamically when the source data changes.

Solution 2

Use Linked Pictures for Small Datasets

For summary reports with a limited number of items, you can use the Linked Picture feature to display live images next to your Pivot Table data.

Free Microsoft Office alternative

Try WPS Office for Your Data Analysis Needs

If you are struggling with Excel's limitations when handling complex objects like images in Pivot Tables, consider trying WPS Office. It provides a lightweight, highly compatible alternative for creating detailed reports and managing spreadsheets without expensive subscriptions.

1. Download and Install: Download WPS Office Free from the official website and install it on your device.
2. Open Your Spreadsheet: Launch WPS Spreadsheet and open your existing .xlsx file containing your data and images.
3. Analyze Data: Navigate to the Insert tab and select Pivot Table to easily summarize and analyze your data with robust compatibility.

Seamlessly open, edit, and save Microsoft Excel (.xlsx) files with high format compatibility.Create powerful Pivot Tables and dynamic charts completely for free.Lightweight installation ensures fast performance even with large datasets.Familiar, intuitive user interface allows for a zero learning curve when migrating.

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel Pivot Table display the word 'Picture' instead of the image?

This occurs because Microsoft Excel's Pivot Table engine does not fully support rendering the newer 'Image in Cell' data type. Instead of rendering the actual graphical object inside the pivot cache, the Pivot Table defaults to displaying the text placeholder 'Picture'.

Will updating Microsoft 365 fix the images in my Pivot Table?

While updating Microsoft 365 ensures you have the latest feature rollouts and bug fixes, native Pivot Tables may still struggle to display in-cell images directly due to current architectural limitations. Using lookup formulas remains the most reliable workaround.

Can I manually copy and paste images into the Pivot Table?

While you can paste floating images over a Pivot Table, it is highly discouraged for large datasets. It will drastically increase your file size, and floating images will not filter, sort, or update dynamically if the underlying Pivot Table structure changes.

Excel & Data Problems