Pivot Table Issues

Fix Excel PivotTable Not Displaying Embedded Cell Images

Phi Hung Vo Sep 30, 2026 869 views

Question details

The user needs to display images in a PivotTable, but the table only shows the word 'Picture' instead of the actual images inserted using the Place in Cell feature.

How to Fix Excel PivotTable Not Displaying Embedded Cell Images

Product: Microsoft Excel
Device & OS: not provided
Scenario: Creating a PivotTable report that relies on visual data representations originally embedded directly within the source cells.
Observed behavior: The PivotTable fails to render the embedded cell images and instead replaces them with the text placeholder 'Picture'.

Before you start

Understand that PivotTables are fundamentally designed to aggregate numeric and text data. Direct rendering of embedded cell images is not natively supported, so you will need to utilize text-based or hyperlink workarounds.

Solution 1Recommended

Use Hyperlinks to Reference Images

Instead of embedding images directly into cells, use hyperlinks so users can click to view the original image in a browser or local folder.

This method ensures that your PivotTable remains clean and functional while still providing users with direct access to the visual data they need.

Insert image URLs

In your source data table, replace the embedded image column with a URL or file path linking to the location of the image.

Create a hyperlink formula

Use the =HYPERLINK() function in an adjacent column to make the link clickable and give it a friendly name (e.g., 'View Image').

Refresh the PivotTable

Include this new hyperlink column in your PivotTable source range, check the box in the PivotTable Fields pane, and refresh the data to display the clickable links.

Hyperlink Functionality: In some versions of Excel, hyperlinks may lose their clickability inside a PivotTable. If this happens, right-click the cell and select 'Open Hyperlink' or use VBA to restore single-click functionality.

Solution 2

Replace Images with Descriptive Text or Categories

Use meaningful text labels or IDs in your source data to represent the visual information for categorization.

Free Microsoft Office alternative

Try WPS Office for Seamless Spreadsheet Management

While standard PivotTables in any spreadsheet program have limitations with embedded images, WPS Spreadsheet provides a robust, lightweight, and completely free alternative to Microsoft Excel. It offers an intuitive interface and excellent compatibility for handling all your data analysis and PivotTable reporting needs.

1. Download and Install: Visit the official WPS website to download and install the free WPS Office suite on your device.
2. Open Your Data: Launch WPS Spreadsheet and open your existing .xlsx files directly without any formatting loss.
3. Analyze with Ease: Use the Insert PivotTable feature to summarize, filter, and analyze your data just as you would in Microsoft Excel.

Fully compatible with Microsoft Excel (.xlsx, .xls) formatsRobust PivotTable features for complex data aggregation without lagLightweight installation and smooth performance for large data setsFamiliar user interface requiring zero learning curve for Excel users

microsoft office alternative - wps office

Frequently Asked Questions

Why does my PivotTable show the word 'Picture' instead of the actual image?

PivotTables are designed to aggregate text and numeric data. When encountering embedded cell images, the software defaults to displaying the text placeholder 'Picture' because it cannot calculate, sum, or group visual media.

Can I use VBA to display images in an Excel PivotTable?

Yes, advanced users can write VBA macros to dynamically insert and align floating images over specific PivotTable cells based on the source data, though this requires programming knowledge and can be unstable when the layout changes.

Are there any add-ins that allow images in PivotTables?

Some third-party BI tools, such as Power BI, offer custom visual capabilities that can display images within tables and matrix visuals. However, standard Excel PivotTables do not support this natively via simple add-ins.

Does the 'Place in Cell' feature work anywhere else in Excel?

Yes, images inserted using 'Place in Cell' will display correctly in standard worksheets. They allow for sorting and filtering, and can be referenced by certain lookup formulas like XLOOKUP, even if they cannot be rendered inside a PivotTable.

Excel & Data Problems