Office Compatibility Issues

Display Dynamic Images on Multiple Sheets in Excel for the Web

Camila MilosovichCamila Milosovich Nov 18, 2026 870 views

Question details

Display images from a central source on multiple sheets in Excel for the web without relying on Camera Tool objects.

Display Dynamic Images on Multiple Sheets in Excel for the Web
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.
Before you start

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.

Solution 1Recommended

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.

1
Create a URL 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.

2
Display an image on another sheet

Select a cell on a destination sheet and enter =IMAGE(Images!A2). Press Enter to display the image referenced by the central sheet.

3
Repeat on other sheets

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.

4
Update the source

Replace the URL in Images!A2 with another accessible image URL to update formulas that reference that cell.

Use image URLs and the IMAGE function across sheets
This is not a Camera Tool snapshot: IMAGE displays an image from a URL; it does not create a live picture of a worksheet range. Availability can depend on your Excel version and organization settings.
Free Microsoft Office alternative

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.

Insert and work with pictures in spreadsheet sheetsOpen and edit Microsoft Excel XLSX filesUse a familiar spreadsheet interfaceGet a free, lightweight Office alternative
microsoft office alternative - wps office

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.