How to Keep Captions When Updating a Linked Excel Table in Word
Question details
The user needs a method to prevent captions attached to a linked Excel table from disappearing whenever the link is updated within a Word document.
- Product
- Word Processing Software
- Device & OS
- not provided
- Scenario
- Refreshing or updating a linked Excel object inside a Word document after making changes to the source file.
- Observed behavior
- Captions that are embedded directly inside the linked Excel object are deleted or lost automatically when the link is refreshed.
Ensure you have saved both your source Excel spreadsheet and your current Word document before restructuring the object placements.
Insert the Caption in a Separate Paragraph Outside the Linked Object
By placing the caption in a standard text paragraph instead of embedding it within the Excel object container, the text remains independent and intact during data updates.
When an Excel table is inserted into Word as a linked object, updating the link prompts Word to pull the newest data directly from the original Excel file. If you type a caption directly inside the borders of that linked object, Word replaces the entire contents of the container during the refresh, erasing your added text.
Click immediately above or below the linked Excel table in your Word document and press the 'Enter' key to create a new, separate paragraph outside the object's selection boundaries.
Navigate to the 'References' tab on the top ribbon, or use the search box at the top of the application to find 'Insert Caption'.
Click 'Insert Caption', select your preferred label (such as Table or Figure), type out your caption text, and click 'OK'. The caption will now appear in the separate paragraph.
Right-click the linked Excel table and select 'Update Link'. Because the caption is safely located in an independent paragraph, it will not disappear when the table refreshes.
Manage Linked Excel Data and Captions Easily in WPS Writer
WPS Office offers intuitive reference tools and a highly stable environment for embedding and linking spreadsheet data within your documents. You can easily insert captions outside linked objects, ensuring no data is lost during routine updates.
- 1. Open your document in WPS Writer: Launch WPS Office, open WPS Writer, and load the document containing your linked spreadsheet.
- 2. Add a separate paragraph: Click directly above or below the embedded table and press 'Enter' to step out of the object's bounding box.
- 3. Use the References tab to add the caption: Go to the 'References' tab, click 'Caption', type your descriptive text, and hit OK. The caption will remain permanently intact when you refresh the linked data.
Frequently Asked Questions
Why does my typed text disappear when I update a linked object in Word?
When a linked object is updated, the word processor fetches the latest structural and visual data from the source file. Anything typed manually inside the object container in Word is overwritten because it does not exist in the original source file.
How can I keep the caption and the linked Excel table on the same page?
To prevent the caption from separating from the table across page breaks, you can select the paragraph containing the caption, open the 'Paragraph' settings, and check 'Keep with next' under the Line and Page Breaks tab.
Will a separately placed caption still appear in my Table of Figures?
Yes. As long as the caption is inserted using the official 'Insert Caption' tool from the References tab, the word processor tracks the caption's formatting style and will automatically include it when you generate or update a Table of Figures.
