'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Excel PivotTable Showing 'Picture' Instead of Images
Question details
Users attempting to include images in an Excel PivotTable see the text 'Picture' instead of the actual images rendering.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Creating a PivotTable using a dataset that contains images inserted directly inside the cells.
- Observed behavior
- The PivotTable displays the word 'Picture' as a placeholder rather than rendering the actual images from the source data.
Ensure you have an active Microsoft 365 subscription, as the image support feature in PivotTables is currently tied to specific update channels and Insider builds.
Join the Microsoft 365 Insider Program
Access the latest features, including full image support in PivotTables, by switching your Office installation to an Insider build.
Support for images and data types in Excel PivotTables is initially rolled out to Microsoft 365 Insiders. If you are on a standard stable release, Excel will default to showing the text 'Picture'. By joining the Insider program, you can test and use this feature before its general release.
Launch Microsoft Excel, click on 'File' in the top-left corner, and select 'Account' from the bottom left menu.
Look for the 'Microsoft 365 Insider' section on the right side of the screen. Click the button and select 'Join Microsoft 365 Insider'.
Check the box to sign up for early access, then select either the 'Beta Channel' or 'Current Channel (Preview)' from the dropdown list. Agree to the terms and click 'OK'.
Under the 'Product Information' section, click on 'Update Options' and select 'Update Now'. Excel will download and install the latest Insider build containing the image support feature.
Use WPS Office for Powerful Data Analysis and PivotTables
If you are tired of waiting for Microsoft 365 updates or navigating complex Insider programs, try WPS Office. It is a lightweight, completely free alternative that offers comprehensive spreadsheet tools, including advanced PivotTables, seamless Excel compatibility, and a familiar user interface.
- 1. Download and Install WPS Office: Visit the official WPS website, download the free version, and follow the simple installation prompts.
- 2. Open Your Existing Spreadsheets: Launch WPS Spreadsheet and easily open your existing Microsoft Excel files without worrying about format corruption.
- 3. Create Advanced PivotTables: Select your data range, navigate to the 'Insert' tab, and click 'PivotTable' to start analyzing your data efficiently.
Frequently Asked Questions
Why do my images show up as the word 'Picture' in Excel PivotTables?
This happens because standard versions of Excel do not yet natively support rendering in-cell images within PivotTables. Instead of showing an error, Excel returns the placeholder text 'Picture' to indicate an image is present in the source data.
When will image support in PivotTables be available to everyone?
Microsoft typically tests new features in the Insider program first. Once testing is complete and the feature is stable, it will be rolled out to all Microsoft 365 subscribers in a future global update.
Can I use images in PivotTables in older Excel versions like Excel 2019?
No, the ability to display images natively inside PivotTables is a modern feature introduced exclusively for Microsoft 365. Older perpetual versions like Excel 2019 or Excel 2021 will only display the 'Picture' text.
