How to Fix Word Deleting Pictures When Updating Linked Excel Tables
Question details
The user needs to prevent pictures and text boxes from being deleted when updating a linked Excel table in a Word document.
- Product
- Microsoft Word
- Device & OS
- not provided
- Scenario
- Updating a linked Excel table that spans three or more pages in a Word document, which causes nearby anchored images and text boxes to disappear.
- Observed behavior
- When the linked Excel table is updated, the table repositions itself, the first row stops repeating, and associated pictures or text boxes are unexpectedly deleted.
Before attempting these fixes, make sure you have saved a backup copy of your Word document to ensure you do not permanently lose any images if they are accidentally deleted during troubleshooting.
Move Image Anchors Outside the Table Area
Repositioning the image anchors prevents them from being embedded in the table, stopping Word from deleting the images during a table update.
Every floating picture or text box in Word has an invisible anchor connecting it to a specific paragraph. When a table spans multiple pages, anchors placed on the middle pages can become trapped inside the table structure. When the linked table refreshes, these embedded anchors are wiped out, taking your pictures with them.
Click on the picture or text box in your Word document. A small anchor icon should appear in the left margin next to the paragraph it is attached to.
Click and hold the anchor icon, then drag it to a standard text paragraph outside of the linked table area (preferably above or below the table).
Right-click the image, select 'Size and Position', navigate to the 'Position' tab, and change both horizontal and vertical positioning to 'Absolute position' relative to the Page or Margin.
Disable Text Wrapping and AutoFit for the Linked Table
Turning off text wrapping minimizes the chance of the table interfering with nearby floating objects and anchors.
Place Pictures Directly Inside the Source Excel File
By adding the images to the Excel spreadsheet instead of Word, you bypass Word's anchor deletion bug entirely.
Switch to WPS Office for Stable Document Formatting
If Microsoft Word continues to struggle with unexpected formatting changes and object deletion when updating linked spreadsheets, consider switching to WPS Office. It provides a lightweight, highly compatible environment for your documents without these frustrating layout glitches.
- 1. Download and Install WPS Office: Visit the official WPS website to download the free office suite and install it on your computer.
- 2. Open Your Document in WPS Writer: Launch WPS Writer and open your existing .docx file containing the linked tables and images.
- 3. Manage Linked Data Safely: Update your linked spreadsheets securely, knowing your anchored pictures and complex layouts will remain intact.
Frequently Asked Questions
Why does updating a linked table change my table formatting in Word?
When a linked Excel table is updated, Word attempts to pull the exact formatting from the source Excel file. If you have manually formatted the table in Word and the 'Preserve formatting after update' option is not checked in the link settings, your custom formatting will be overwritten.
How do I stop a table's first row from disappearing when updating?
This happens when the update overrides Word's 'Repeat Header Rows' setting. You can fix this by defining the print titles/header rows directly in the source Excel file via Page Setup, or by simply reapplying the header row setting in Word after the update is complete.
Can I lock an image's anchor to a specific paragraph permanently?
Yes. Select the image, click the layout options icon, choose 'See more', go to the 'Position' tab, and check the 'Lock anchor' box. This ensures the anchor stays attached to its designated paragraph, reducing the chance of it shifting into an updating table.
