Keep Microsoft Excel Takeoff Form Links Working After Renaming a Workbook
Question details
The user needs to rename an Excel takeoff-form workbook without breaking Microsoft Word documents that link to the workbook.

- Product
- Microsoft Excel and Microsoft Word
- Device & OS
- not provided
- Scenario
- An Excel workbook is saved under a new file name while linked Word content must continue to reference the correct takeoff form.
- Observed behavior
- Word links can retain the former workbook name or path and no longer update after the Excel file is renamed or moved.
Confirm whether the Word content is linked rather than fully embedded, because a truly embedded object does not update from the original workbook. Keep the Excel workbook and related Word files accessible while you change the file name and link source.
Keep the Excel workbook and Word documents in a stable shared folder
Use this approach before renaming files to reduce broken paths across recurring takeoff-form workflows.
Links are more reliable when related files remain together in the same folder structure. Relative links can continue to work when the entire project folder is moved, but they may fail if only the workbook is renamed or relocated.
In File Explorer, create a project folder and store the Excel takeoff workbook and its related Word documents in that folder or in consistent subfolders.
In Excel, select File > Save As, choose the existing project folder, and save the workbook under the new name. Avoid moving it to a different drive, network location, or unrelated folder at the same time.
If multiple people update the files, place the complete project folder in one controlled shared location, such as an approved network share or synchronized team folder, and have users open files from that location.

Update the Excel source in Microsoft Word after renaming the workbook
Use this when Word shows an error, outdated values, or a prompt that the linked Excel source cannot be found.
Use a VBA routine for repeated workbook-name changes
Use this for standardized workflows where the same linked Word documents must be updated whenever a takeoff workbook is renamed.
Use WPS Office for Compatible Excel and Word Project Files
If your workflow is being disrupted by Microsoft Office link management, WPS Office provides a free, lightweight office suite with a familiar interface for opening and editing project documents. You can migrate Excel takeoff forms and Word files with strong format compatibility, while validating linked or embedded objects before relying on them in a production workflow.

Frequently Asked Questions
Why do Word links break when I rename an Excel workbook?
A linked Word object often stores the Excel workbook's file name and full path. After a rename, Word may still search for the old source until you select File > Info > Edit Links to Files > Change Source.
What is the difference between embedded and linked Excel content in Word?
Embedded content is stored inside the Word document and does not automatically refresh from the original workbook. Linked content remains connected to an external Excel file and can be updated through File > Info > Edit Links to Files.
Can I move the Excel and Word files to another folder without breaking links?
You can reduce failures by moving the entire project folder together while preserving its internal folder structure. If Word still cannot locate the workbook, use File > Info > Edit Links to Files > Change Source to select the new location.
Where can I update an external workbook link in Excel?
In desktop Excel, select Data > Edit Links when the workbook contains external links to other workbooks. This command manages Excel-to-Excel references; Word-to-Excel links are normally updated from Word's File > Info > Edit Links to Files dialog.




