Display Dynamic Images on Multiple Sheets in Excel for the Web
Question details
Display images from a central source on multiple sheets in Excel for the web without relying on Camera Tool objects.

- Product
- Excel for the web
- Device & OS
- not provided
- Scenario
- A workbook uses a central image sheet to provide images for other sheets.
- Observed behavior
- Excel for the web does not support Camera Tool objects used for linked image snapshots.
Check whether the IMAGE function is available in your Excel for the web environment. For that method, prepare accessible HTTPS links that point directly to the images; a link to a webpage or a picture embedded in a worksheet is not enough.
Use image URLs and the IMAGE function across sheets
Use this method when you have accessible image URLs and want cells on multiple sheets to display images from a central list.
On a central sheet named Images, enter a direct HTTPS image URL in cell A2 and add other image URLs in the cells below it.
Select a cell on a destination sheet and enter =IMAGE(Images!A2). Press Enter to display the image referenced by the central sheet.
Enter the same formula on each sheet where the image is needed, or change the cell reference to display a different URL from the Images sheet.
Replace the URL in Images!A2 with another accessible image URL to update formulas that reference that cell.

Insert pictures directly on the required sheets
Use this option when images do not need to update automatically from a central source.
Work with spreadsheet images in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheets and pictures. Open compatible Excel files to move your work across with ease, though WPS does not fix Camera Tool support in Excel for the web.

Frequently Asked Questions
Can the IMAGE function display a Camera Tool snapshot?
No. IMAGE displays an image from a URL, such as =IMAGE(Images!A2). It does not create a linked snapshot of a worksheet range.
How can I show the same image on several sheets?
Store a direct image URL in a central cell, such as Images!A2, and enter =IMAGE(Images!A2) on each destination sheet. Changing the URL updates formulas that reference that cell.
Why does my IMAGE formula not show a picture?
Check that IMAGE is available in your Excel environment and that the referenced cell contains an accessible direct HTTPS image URL. Organization settings or restricted image access can also affect availability.
What can I use for a live picture of a cell range?
Use the Camera Tool in desktop Excel for a linked range snapshot. Excel for the web does not support displaying Camera Tool objects.




