Link a Copied Excel Workbook to the Original Workbook
Question details
The user wants cells in a copied workbook to reflect changes made in the original workbook.

- 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.
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.
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.
Open the original workbook in Excel, select the cells you want to link, and choose Home > Copy.
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.
Save the destination workbook. After changing the source, save it and update external links when Excel prompts you, if you trust the source.
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.

Enter an external-reference formula
Use a formula when you need to link an individual cell or build a specific reference.
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. Open both workbooks: Open the original and destination files in WPS Spreadsheets, and identify the source sheet and cell.
- 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. Fill additional cells: Press Enter and drag the cell's fill handle to adjacent cells if you need corresponding source values.
- 4. Save and check updates: Save both workbooks. After editing the source, save it and reopen or update the destination link if prompted.

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.




