WPS Spreadsheets: Change External Workbook Links in One Copied Row
Question details
Update external workbook references in a copied spreadsheet row without changing links elsewhere in the original worksheet.
- Product
- WPS Spreadsheets
- Device & OS
- not provided
- Scenario
- A row containing external workbook formulas has been copied to another location, and only the copied row needs to point to a different workbook.
- Observed behavior
- Changing the external reference broadly could affect formulas outside the copied row; the goal is to replace the reference only in the selected destination row.
Identify the existing workbook reference and the replacement reference, such as [B.xlsx] and [C.xlsx]. Paste the copied row into its destination first, then select only that pasted row before opening Find and Replace.
Replace the external workbook reference only in the pasted row
Use this method when the copied row should link to a different workbook while all other worksheet formulas must remain unchanged.
Selecting the destination row before running Find and Replace limits the replacement scope to that row. Searching within formulas ensures that the workbook name inside references such as =[B.xlsx]Sheet1!$A$1 is updated rather than matching visible cell values.
Select the row containing the external links, press Ctrl+C, select the destination row, and press Ctrl+V.
Click the row header for the pasted destination row, or drag across the pasted cells if only part of the row contains the formulas.
With the pasted row selected, press Ctrl+H to open the Find and Replace dialog.
Enter the old workbook reference, such as [B.xlsx], in Find what and the new reference, such as [C.xlsx], in Replace with. Open the dialog options, set the search area to formulas if available, and click Replace All.
Click several cells in the pasted row and check the formula bar to confirm that the new workbook reference appears. Check cells in the original worksheet to make sure their links were not changed, then save the file.
Update External Workbook Links Safely in WPS Spreadsheets
WPS Spreadsheets lets you copy a formula row, limit the selection to the pasted row, and use Find and Replace to update external workbook references without altering other worksheet links.
- 1. Paste the copied row: Open the worksheet in WPS Spreadsheets, copy the source row, and paste it into the destination row.
- 2. Limit the selection: Select only the pasted row before making any replacement.
- 3. Replace the old workbook name: Press Ctrl+H, enter the old and new workbook references, choose formula searching when available, and select Replace All.
- 4. Check and save: Review the pasted row and a few original cells in the formula bar, then save the workbook.
Frequently Asked Questions
How can I replace an external workbook name without changing the whole worksheet?
Select only the copied destination row, press Ctrl+H, enter the old and new workbook references, and run Replace All while that row remains selected.
Should I search formulas or cell values?
Search within formulas. External workbook names are stored inside formulas, such as =[B.xlsx]Sheet1!$A$1, rather than as visible cell values.
Can I replace only part of an external reference?
Yes. Enter the workbook portion, such as [B.xlsx], in Find what and the replacement workbook portion, such as [C.xlsx], in Replace with. Confirm the formulas afterward.
What happens if I do not select the pasted row first?
Find and Replace may scan a larger worksheet range and update matching workbook references outside the copied row. Select the target row before opening Ctrl+H.
How do I confirm that the original links were not changed?
Click cells in both the pasted row and the original worksheet, then review their formulas in the formula bar. The pasted row should show the new workbook name while the original cells retain the old reference.
