How to Update External Excel Workbook Links After Renaming a File
Question details
The user needs to update external workbook links after the source file was renamed in Windows Explorer, so formulas such as VLOOKUP and XLOOKUP continue pointing to the correct workbook.
- Product
- WPS Office Spreadsheet
- Device & OS
- Windows
- Scenario
- A user renamed an external source workbook in Windows Explorer and now needs to point existing workbook links to the renamed file.
- Observed behavior
- Excel does not automatically update external workbook references after the source file is renamed; formulas such as VLOOKUP and XLOOKUP may continue pointing to the old file name or show broken links.
Make sure the renamed source workbook is saved in a known folder and note its exact file name and location. Close both the source workbook and the linked workbook before changing links to avoid file lock conflicts.
Update External Workbook Links with the Edit Links to Files Dialog
Use this method when the source workbook has already been renamed and you want to repoint all formulas to the new file without recreating them.
Renaming a file in Windows Explorer changes only the file name, not the reference stored inside the linked workbook. Editing the link source updates the file path while preserving formulas and cell ranges.
Launch WPS Office, open the workbook that contains VLOOKUP, XLOOKUP, or other external links, and make sure the renamed source workbook is available on your computer.
Go to File > Info > Edit Links to Files. If your version shows a different layout, look for the external link management command under File or Data.
In the Edit Links dialog, select the old source workbook from the list, click Change Source, browse to the renamed workbook, select it, and confirm.
Click Update Values if available to refresh the formulas, then save the workbook to keep the new link source.
Repoint Links by Saving the Renamed Workbook with Save As
Use this approach when you can open both the source workbook and the linked workbook in the same session and want to preserve the link relationship.
Update External Workbook Links in WPS Office Spreadsheet
WPS Office Spreadsheet lets you open Excel workbooks, update external link sources after a rename, and keep formulas like VLOOKUP and XLOOKUP working without recreating them.
- 1. Download and install WPS Office: Download WPS Office from the official website and install it on your Windows or Mac computer.
- 2. Open the linked workbook: Open the .xlsx or .xls workbook that contains the external links in WPS Office.
- 3. Open Edit Links to Files: Go to File > Info > Edit Links to Files to see the linked workbooks.
- 4. Change Source and select the renamed file: Select the old source, click Change Source, and browse to the renamed external workbook.
- 5. Save the workbook: Update values and save the workbook to keep the new source link active.
Frequently Asked Questions
Why does Excel still look for the old file name after I rename a source workbook?
Renaming a file in Windows Explorer changes only the file name; it does not update the reference stored in the linked workbook. Open File > Info > Edit Links to Files and use Change Source to select the renamed file.
Will updating the link source break my VLOOKUP or XLOOKUP formulas?
No, if the formulas reference the same cell ranges in the renamed workbook. Change Source updates the file path while preserving the formulas. Use Update Values to refresh results.
Can I update external links if the old source file is missing or already deleted?
You cannot browse to a deleted file, but if you have a backup or renamed copy, use Change Source and select it. If the old source workbook can still be opened, save it under the new name with Save As and then save the linked workbook.
Where is Edit Links to Files in WPS Office?
Open the workbook and go to File > Info > Edit Links to Files. Depending on the version, the command may also appear under Data > Edit Links or in the File menu.
Do I need to open both workbooks to update external links?
Not always. The Change Source method only requires the renamed source file to exist and be selectable. The Save As method requires opening both the source workbook and the linked workbook.
