Financial model review
External workbook links in financial models
Find and review links to other Excel workbooks in a financial model. Check the source and decide what to retain or change while preserving original formulas.

An external workbook link is a formula reference to another Excel file. Its presence is not proof of an error: a model may intentionally depend on an approved budget or assumptions workbook. The useful review question is whether that dependency is available, current and understood by the person receiving the model.
What does an external link look like?
Consider this invented formula in Forecast!D12:
='[Budget.xlsx]Assumptions'!$B$4*C12
Budget.xlsx identifies the other workbook, Assumptions its sheet, and $B$4 the referenced cell. C12 belongs to the current sheet. A link to another sheet in the same file, such as =Assumptions!B4*C12, is a local reference instead. Microsoft explains this distinction in its workbook-link guide.
In this example, a reviewer should establish what B4 represents before changing anything. It could be a growth assumption, a price or a conversion factor. The filename alone cannot establish its purpose or whether the value is appropriate.
Review the dependency before removing it
- Preserve a copy of the model before editing links.
- Open the indicated sheet and cell; compare the formula bar with the reported evidence.
- Confirm the intended source file and its owner. Ask whether the model recipient will have access to the same source.
- Inspect the source assumption, its units and the period it covers. Record why the dependency exists.
- Decide whether to keep it, point it to an approved replacement, or replace the dependency through a deliberate model change.
Excel's workbook-link controls can help inspect and change a source. Available menus differ by Excel version. Breaking a link can replace linked formulas with their current values, so it can remove the calculation logic you intended to retain. Keep the original before using that command. Microsoft's link-management documentation describes these operations.
For the worked example, replacing the source with a local input might make sense if the model must travel independently. It still requires a deliberate decision about maintaining that input. Copying a number is not equivalent to verifying it.
What a saved-workbook report can establish
An external-link Finding can identify a supported formula reference at a precise sheet and cell. A link recorded only in workbook metadata can be reported without a sheet or cell. That does not establish that the metadata is unused.
Use the free detailed PDF to locate reported references before reviewing them in Excel. Ordinary formula checks do not establish that charts, names, queries and every other Excel feature were audited. FinModelCheck does not fetch the referenced file, test its availability or recalculate Excel. An absence of Findings does not establish that all external dependencies were checked.
View the synthetic example report before trying the checker. For related review questions, read about embedded assumptions and saved Excel errors.
Short answers
Are all external workbook links broken?
No. A link can be intentional and useful. Its correctness depends on the source, permissions, values and intended workflow.
Can I remove every link to make a model safer to share?
Review first. Removing a dependency can freeze an outdated number or destroy a formula. Choose and document a replacement rather than treating every link as unwanted.
Does a zero-Finding report prove there are no external dependencies?
No. It means none were reported by the supported checks. Charts, names, queries and other Excel features may still contain dependencies and need a separate review.


