You have a linked picture in Excel that shows a range of cells, but the picture stays frozen even after you change the source data. This usually happens because Excel treats the linked picture as a static snapshot after certain operations such as copying the picture to another sheet or workbook. The picture does not refresh automatically because the link between the picture and the source range has been broken or the update mode is set incorrectly. This article explains why the linked picture stops updating and provides step-by-step fixes to restore its dynamic behavior.
Key Takeaways: Fixing a Non-Updating Linked Picture in Excel
- Right-click the picture > Update Link: Forces an immediate refresh of the linked picture from the source range.
- Right-click the picture > Format Object > Properties > unchecked Locked: Prevents the picture from being treated as static when the workbook is saved and reopened.
- Delete and reinsert the picture using Camera tool: Recreates a clean dynamic link when the original link is corrupted.
Why Excel Linked Pictures Stop Updating
A linked picture in Excel is an image object that displays the current content of a specified cell range. When you change data in the source range, the picture should update automatically. The link is maintained through a formula that references the source range, similar to a named range or a defined name. However, several actions can break this link or prevent the picture from refreshing:
Copying the picture to a different sheet or workbook often converts the dynamic link into a static image. Excel also stops updating linked pictures if the source range is deleted, moved, or renamed. Another common cause is when the picture is locked on the worksheet, which prevents Excel from recalculating the link when the workbook is recalculated. Additionally, if the workbook calculation mode is set to Manual, the picture will not update until you press F9 to recalculate.
The Camera Tool and Linked Picture Behavior
The Camera tool in Excel creates a live picture of a range. This picture updates automatically as long as the source range remains on the same sheet and the link formula is intact. If you copy the Camera picture to another location, Excel may replace the dynamic link with a static reference that does not refresh. The same issue occurs when you use the Paste Special > Linked Picture command. Understanding this distinction helps you choose the correct fix method.
Steps to Force the Linked Picture to Update
Try these methods in order. Each method addresses a different reason why the picture stopped updating. Test the picture after each step before moving to the next method.
Method 1: Use the Update Link Command
- Right-click the linked picture
A context menu appears. Look for the option Update Link at the bottom of the menu. If this option is grayed out, the picture is not linked or the link is broken. - Click Update Link
Excel refreshes the picture from the source range immediately. If the picture updates, the issue was a stale link that needed manual refresh. - Check the formula bar
Click on the picture. Look at the formula bar. You should see a formula like=Sheet1!$A$1:$C$10. If the formula bar is empty or shows a static file path, the link is broken and you need to reinsert the picture.
Method 2: Recalculate the Workbook
- Press F9 on your keyboard
This recalculates all formulas in the workbook, including linked picture formulas. If the picture updates, the workbook was set to Manual calculation mode. - Change calculation mode to Automatic
Go to Formulas > Calculation Options > Automatic. This ensures that linked pictures update automatically whenever source data changes.
Method 3: Unlock the Picture Object
- Right-click the picture and select Format Object
The Format Object dialog opens. Click the Properties tab. - Uncheck the Locked checkbox
Under Object positioning, clear the Locked checkbox. Click OK. This allows Excel to recalculate the picture during workbook recalculation.
Method 4: Reinsert the Linked Picture Using the Camera Tool
- Add the Camera tool to the Quick Access Toolbar
Click File > Options > Quick Access Toolbar. In the Choose commands from dropdown, select Commands Not in the Ribbon. Scroll down to Camera, click Add, then OK. - Select the source range
On your worksheet, select the range of cells you want to capture in the picture. - Click the Camera button on the Quick Access Toolbar
Excel copies the range as a live picture to the clipboard. - Click on the destination cell
Excel inserts the linked picture. The formula bar shows the source range reference. Test by changing a value in the source range. The picture should update instantly.
Method 5: Use Paste Special > Linked Picture
- Copy the source range
Select the range and press Ctrl+C. - Go to the destination location
Click the cell where you want the top-left corner of the picture to appear. - Right-click and choose Paste Special
In the Paste Special dialog, click Linked Picture under Other Paste Options. A dynamic picture appears. Verify the formula bar shows the source reference.
If the Linked Picture Still Does Not Update
Some scenarios require additional troubleshooting beyond the main methods. The following issues are common when linked pictures fail to refresh.
Linked Picture Shows a File Path Instead of a Range Reference
If you see a formula like =C:\Users\...\[Workbook.xlsx]Sheet1!$A$1:$C$10, the picture is linked to an external file. Excel does not automatically update linked pictures from external workbooks unless both workbooks are open. Open the source workbook, then right-click the picture and choose Update Link. To avoid this, keep the source range in the same workbook.
Linked Picture Does Not Update After Saving and Reopening
This occurs when the picture object is locked or when the workbook is opened in Protected View. Save the workbook to a trusted location. Right-click the picture, go to Format Object > Properties, and uncheck Locked. Then save and reopen the file.
Linked Picture Shows a Blank or Gray Box
The source range may have been deleted or the sheet name may have changed. Check the formula bar for the reference. If it shows =#REF!, the source no longer exists. Delete the picture and reinsert it using the Camera tool with the correct range.
Camera Tool vs Paste Special Linked Picture: Key Differences
| Item | Camera Tool | Paste Special > Linked Picture |
|---|---|---|
| Insertion method | Adds Camera button to Quick Access Toolbar, then click to capture range | Copy range, right-click destination, choose Paste Special > Linked Picture |
| Update behavior | Updates automatically when source data changes, even without selecting the picture | Updates automatically, but may require a manual F9 if calculation mode is Manual |
| Link formula | Always shows a simple range reference like =Sheet1!$A$1:$C$10 |
Shows a range reference, but may include workbook path if pasted across workbooks |
| Best use case | Creating a live dashboard or summary view on the same worksheet | Quickly inserting a linked picture on a different sheet or workbook while both are open |
You can now fix a non-updating linked picture in Excel using the Update Link command, recalculation, unlocking the object, or reinserting the picture with the Camera tool. Start by checking the formula bar to confirm the link exists. If the link is broken, use the Camera tool to create a fresh dynamic picture. For recurring issues, always keep the source range on the same sheet and set calculation mode to Automatic. An advanced tip: name the source range with a defined name (Formulas > Define Name) and use that name in the Camera picture formula for a link that survives sheet renames.