Excel Linked Picture Updates Only When the Source Workbook Is Open
Question details
The user needs to understand why an Excel Linked Picture does not refresh after the source workbook is closed and how to preserve the linked formatting.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- An Excel range is pasted as a Linked Picture or created with the Camera tool, and the user wants the destination image to update even when the source workbook is closed.
- Observed behavior
- The linked picture updates while both the source and destination workbooks are open, but it stops refreshing after the source workbook is closed.
Identify the source workbook, destination workbook, and the exact range used for the Linked Picture or Camera object. Open both files and confirm that the object is linked to the expected source range before testing an alternative.
Keep the source workbook open while using an Excel Linked Picture
Use this approach when preserving the exact picture-based formatting is more important than updating from a closed workbook.
Excel Linked Pictures and Camera objects generally depend on the source workbook being open. They can reflect source changes while both workbooks are active, but they are not designed to refresh reliably from a closed source file.
Launch Excel and open the source workbook together with the destination workbook that contains the Linked Picture.
Edit the cells or formatting in the source range, then save the source workbook using File > Save.
Return to the destination workbook and allow the Linked Picture or Camera object to redraw while the source workbook remains open.
Use a normal paste link or an automated image workflow
Choose this option when the source workbook must remain closed or when the picture only needs periodic updating.
Use WPS Office for Lightweight Spreadsheet and Presentation Workflows
WPS Office is a free, lightweight alternative for opening, editing, and sharing common Office files. Its familiar interface supports seamless migration and strong compatibility with Microsoft Excel .xlsx and .xls formats, while helping you manage spreadsheet content without relying on Excel-specific Linked Picture behavior.
- 1. Install WPS Office: Download and install WPS Office, then open the WPS Spreadsheet application.
- 2. Open the Excel workbook: Choose Menu > Open and select the .xlsx or .xls workbook you want to use.
- 3. Edit and save the file: Update the spreadsheet content and choose Menu > Save As to preserve the Microsoft Excel format when sharing the file.
Frequently Asked Questions
Why does an Excel Linked Picture stop updating when the source workbook is closed?
Excel Linked Pictures and Camera objects generally require the source workbook to be open so they can retrieve the referenced range and formatting. They may stop refreshing when that workbook is closed.
Can a normal Excel paste link update from a closed workbook?
A normal cell paste link can often retrieve values from a closed workbook, depending on the file path and link status. However, it does not preserve the same picture-based formatting as a Linked Picture.
Does Excel recalculation fix a Linked Picture that will not update?
Recalculation may refresh formulas, but it usually cannot overcome the Linked Picture or Camera object limitation when the source workbook is closed. Try Formulas > Calculate Now only after opening the source file.
How can I preserve the formatted appearance of a linked range?
Keep the source workbook open while the destination is in use, or use a macro, script, or image-generation workflow that exports the formatted range and replaces the destination image.
