Manage links to other workbooks without silently breaking results

Quick answer: Inspect the source workbook and refresh the link deliberately. If the source moved, use Change source to repair the connection. Break links is different: it replaces linked formulas with their current values and cannot be undone, so make a separate backup first.

Version and platform: Microsoft 365 Excel for Windows desktop; Mac, Excel for the web and Excel 2013 interfaces not covered. Use a disposable workbook for the exercise.

Create two harmless practice workbooks

Create link-source.xlsx with a worksheet named Inputs. Enter Rate in A1 and 12 in B2, then save it in a local practice folder. Create a second workbook, link-report.xlsx, with a worksheet named Report. Keep both files open.

In Report!A1 type Linked value. In B2 type =, switch to link-source.xlsx, select Inputs!B2 and press Enter. Excel constructs the external reference. In the report’s formula bar, verify that the formula identifies link-source.xlsx, Inputs and B2. The result should be 12. In Report!B3 enter =B2*2; expect 24. Save the report separately from its source.

Use only files you created and understand. Do not enable unfamiliar external content or bypass an organizational trust restriction just to complete the example. A blocked refresh is a reason to stop and consult the file owner or administrator, not to weaken Trust Center settings.

Inspect and refresh the link

In the report choose Data → Queries and Connections → Workbook Links. This walkthrough uses the modern Microsoft 365 Windows Workbook Links pane, not Excel 2013’s interface or the older Edit Links dialog.

Select the source workbook in the pane and inspect it. The source should be the practice file you created, not an unrelated similarly named file. The source’s More Commands menu includes Open workbook if you need to inspect its cells.

Change Inputs!B2 in the source from 12 to 15 and save the source. In the report use the source’s Refresh command, or Refresh all if this practice report has only that link. Expect B2=15 and B3=30. If a trust prompt or policy restriction prevents refreshing, do not interpret the last displayed 12 as a current value. Record the blocked state and stop the refresh step.

Repair a changed source location

Save a separate copy of the source as link-source-revised.xlsx, retaining the Inputs sheet and B2 address, and set its B2 to 18. In the report’s Workbook Links pane, choose More Commands → Change source for the original source, browse to the revised file and select it.

Inspect both the displayed result and formula reference. B2 should now be 18, B3 36, and the link should identify the revised file. A correct filename alone is insufficient if the replacement workbook has different sheet names or cell meaning. Check the source cell before accepting the changed connection. Save the live linked report as XLSX.

Make a deliberate fixed-value copy

Save a separate report copy named link-report-snapshot.xlsx before breaking anything. In that copy only, open Workbook Links, choose the revised source’s More Commands menu and select Break links. Review the warning before confirming. Microsoft explicitly states that this conversion cannot be undone.

B2 should still show 18, but its external-reference formula is replaced by the value 18. B3 can remain the local formula =B2*2 and show 36. Change the revised source B2 to 20 and save it. The live linked report should reach 20/40 after a permitted refresh, while the broken-link snapshot remains 18/36. Save the snapshot after breaking its link so the conversion is persisted. Save the live report after its final refresh so its current formula results are recorded. Close both reports only after these saves. This contrast proves the snapshot no longer follows its source.

Reopen and diagnose carefully

Reopen both report files and verify which one is live and which one is fixed. Do not choose settings that silently suppress refresh warnings merely to remove a prompt; stale linked values can look perfectly plausible. Microsoft notes there is no automatic way to find every workbook link: names, objects, chart titles and series can also contain references. A clean-looking cell formula search is not a complete link audit. Restore the backed-up live report if you broke a link unintentionally; the snapshot cannot reconstruct the original formula by itself.

Official references

• Manage workbook links

Documentation snapshots retrieved 20 October 2026. These instructions and example checks are documentation-based; no native Excel run or application screenshot is claimed.