File Sharing Problems

Link a Copied Excel Workbook to the Original Workbook

Muhammad TalhaMuhammad Talha Nov 18, 2026 869 views

Question details

The user wants cells in a copied workbook to reflect changes made in the original workbook.

How to Link a Copied Excel Workbook to the Original
Product
Microsoft Excel
Device & OS
not provided
Scenario
A user wants to maintain a connection between an original workbook and a separate copied workbook.
Observed behavior
The destination workbook should display updated source values when its external links are refreshed.
Before you start

Save both workbooks with distinct names, and identify the source sheet and range you want to link. Keep the original workbook in a stable location that the destination workbook can access.

Solution 1Recommended

Use Paste Link to connect a range to the original workbook

Use Paste Link to create external references for a range without writing each formula manually.

1
Copy the source range

Open the original workbook in Excel, select the cells you want to link, and choose Home > Copy.

2
Paste the links

Open the copied workbook, select the top-left destination cell, and choose Home > Paste > Paste Link. Excel fills the corresponding destination cells with external-reference formulas.

3
Save and update

Save the destination workbook. After changing the source, save it and update external links when Excel prompts you, if you trust the source.

4
Check the connection

Select a linked cell and check its formula in the formula bar. To manage or refresh links, open Data > Workbook Links or Data > Edit Links, depending on your Excel version.

Use Paste Link to connect a range to the original workbook
What the link includes: Paste Link connects the selected cell values, not the entire workbook. It does not automatically link new rows or columns added outside the selected range.
Link workbooks in WPS Spreadsheets

Connect workbook cells with WPS Spreadsheets

Use an external-reference formula in WPS Spreadsheets to display a cell from another workbook, then save and update the workbooks as needed.

  1. 1. Open both workbooks: Open the original and destination files in WPS Spreadsheets, and identify the source sheet and cell.
  2. 2. Enter a link formula: In a destination cell, enter a reference such as ='[WorkbookA.xlsx]Sheet1'!A1, replacing the names and cell address with those from your source workbook.
  3. 3. Fill additional cells: Press Enter and drag the cell's fill handle to adjacent cells if you need corresponding source values.
  4. 4. Save and check updates: Save both workbooks. After editing the source, save it and reopen or update the destination link if prompted.
Link destination cells to values in a source workbookOpen and save Microsoft Excel XLSX filesWork in a familiar spreadsheet interfaceUse WPS Office as a free office suite
microsoft office alternative - wps office

Frequently Asked Questions

Will copying an Excel workbook automatically link it to the original?

No. A copied file is separate unless it contains or is given external references. Use Home > Copy in the source and Home > Paste > Paste Link in the destination to link a range.

How do I refresh links to the original workbook?

Save changes in the source workbook, then update links when Excel prompts you in the destination. You can also check Data > Workbook Links or Data > Edit Links, depending on your Excel version.

What happens if I move or rename the original workbook?

The destination may no longer find the source. Open Data > Workbook Links or Data > Edit Links in Excel and use the available option to change the source location.

Does Paste Link copy formatting or automatically include new rows?

Paste Link creates references to the selected cells; it does not automatically extend the link to new rows outside that range. Apply formatting separately and add links for any additional cells.