Document Editing Problems

How to Update Excel Links After Copying a Worksheet

Maira Mehtab Sep 22, 2026 869 views

Question details

The user needs to redirect formula links to the current workbook after copying an Excel worksheet from another file.

Product: Spreadsheet
Device & OS: not provided
Scenario: Copying an Excel worksheet to a new workbook, resulting in formulas that still reference the original file.
Observed behavior: Formulas in the copied worksheet contain references (e.g., [OriginalFile.xlsx]) pointing back to the original workbook instead of the new or current one.

Before you start

Ensure both the original and the new workbooks are saved on your local drive before attempting to change link sources, as working with unsaved or temporary files may cause link update errors.

Solution 1Recommended

Redirect Links Using the Change Source Feature

The most reliable method to update external links across an entire workbook is by using the built-in Workbook Links tool.

This method is highly recommended because it safely updates all references to the old file simultaneously, ensuring no hidden formulas are left pointing to the incorrect workbook.

Navigate to the Data tab

Click on the Data tab located in the top ribbon menu of your spreadsheet application.

Open Workbook Links

Click on Workbook Links (or Edit Links in some older versions) to open the link management pane.

Select the target link

Locate the original workbook link you want to change from the list of active links.

Change Source

Click the three-dot menu next to the link, select Change source, and navigate to your current workbook file to redirect the references.

Verification: Once the source is successfully changed, the external brackets like [OriginalFile.xlsx] will disappear from your formulas.

Solution 2

Update Specific Formula Links Using Find and Replace

If you only need to update links in specific cells or a single sheet, the Find and Replace tool offers a quick way to strip out the old workbook name.

Edit Spreadsheets Seamlessly

Update Links and Edit Formulas Easily in WPS Spreadsheet

WPS Spreadsheet provides intuitive tools for managing external links and complex formulas. You can effortlessly track, update, or break external workbook links in a few clicks while enjoying full compatibility with all your existing Microsoft Excel files.

1. Open your file: Launch WPS Spreadsheet and open the copied document.
2. Access Data tools: Go to the Data tab on the top ribbon.
3. Open Edit Links: Click Edit Links to view all external workbook references.
4. Update the source: Select the specific link and click Change Source to seamlessly link it to your current file.

Easily track and manage external workbook links from a centralized Data dashboard.Full format compatibility with Microsoft Excel (.xlsx, .xls) files and formulas.Lightweight application that opens large datasets quickly without lagging.Free to use with a familiar, easy-to-navigate tabbed interface.

microsoft office alternative - wps office

Frequently Asked Questions

Why do my formulas still reference the old workbook after copying?

When you copy a sheet to a new file, the spreadsheet application preserves the exact original formula. If a formula referenced another sheet in the original workbook, the app automatically adds the original file's name (e.g., [Book1.xlsx]) to keep the formula mathematically accurate.

What happens if I click 'Break Link' instead of 'Change Source'?

Breaking a link will convert all formulas that rely on that external link into static values. You will permanently lose the formulas themselves, so only use this option if you want to freeze the current calculated numbers.

Can I update links automatically without manual replacing?

Yes, if both workbooks are open in the exact same instance of the software when you move or copy the sheet, relative references will sometimes update automatically. Otherwise, using Data > Edit Links > Change Source is the fastest method to automate the update for the whole workbook.

How do I find all external links hidden in my workbook?

You can press Ctrl + F to open the Find dialog, search for the left bracket [, and set the search scope to 'Workbook' and 'Look in' to 'Formulas'. This will locate all cells containing references to external files.

Document & File Issues