Link external workbooks and manage update prompts

Create an external cell reference by selecting the source cell while building a formula in the destination workbook. Then prove that the destination refreshes from the saved source; seeing the previous value is not proof that a link still works.

Prepare two local workbooks

Use LibreOffice Calc 26.2 desktop with English standard menus on Windows or Linux. This is a documentary workflow, not a native-tested receipt. Use synthetic data in a disposable folder, not an untrusted downloaded workbook.

Save Rates.ods with its first sheet named Rates. Enter Unit cost in A1 and 12 in B1. Save Estimate.ods separately in the same folder. In Estimate, enter Quantity in A1, 5 in B1, Linked cost in A2, and Total in A3. Keep both files open.

The baseline should eventually be a linked unit cost of 12 and a total of 60. Unlike a hyperlink, the reference will contribute a value to a calculation; unlike an imported table, it needs only one source cell.

Build the reference without guessing the path

1. In Estimate, select B2 and start a formula with =.
2. Switch to Rates. Select Rates.B1.
3. Press Enter, or return to Estimate and accept the formula in the formula bar.
4. Inspect B2’s formula. It should identify the source file, sheet and cell. Calc’s external reference syntax includes a file URL followed by the sheet/cell reference.
5. In Estimate.B3 enter =B1*B2. Check B2=12 and B3=60.

Selecting the cell avoids hand-typing operating-system paths, spaces and quoting. If you accidentally selected a different source cell, rebuild the reference deliberately rather than replacing fragments whose meaning is unclear. See worksheet reference checks for the related within-workbook distinction.

Verify updates, not just cached numbers

Change Rates.B1 to 14 and save Rates. In Estimate, use Edit > Links to External Files, select the Rates link and use its update control. Check B2=14 and B3=70. The changed value is the evidence that matters; a destination still showing 12 may only have cached data.

Save and close Estimate. Reopen it and read any external-link update prompt. Permit updating only when the source is the local practice file you recognize. Declining an update is a legitimate choice, but means the displayed values may not reflect the latest source.

Tools > Options > LibreOffice Calc > General documents link-update behavior on opening. Inspect the existing setting; this exercise does not require an always-update policy or a new trusted location. Do not weaken security just to suppress a warning. Files from other people can contain links to locations you did not intend to access.

Recover a moved source

To model a path failure, first retain a backup of both files. Close them, move Rates to a different practice subfolder, and reopen Estimate. A surviving old value does not establish that Calc found the moved file.

Inspect Links to External Files to identify the old target. If the dialog permits changing that link, browse to the known moved Rates file; otherwise recreate B2 by selecting the source cell with both files open. Change the saved source value to 16 and refresh. Expect B2=16 and B3=80. This changed-input check distinguishes a repaired reference from an unchanged cache.

Do not break the link as a repair unless you intentionally want static values. A self-contained snapshot should be labeled with its source and date, because it no longer follows later changes. When transferring the linked model, preserve both workbooks and verify their relationship in the destination location rather than assuming the receiving computer has your paths.

Official references

• LibreOffice documentation 1