Your spreadsheet shows the expected quantities, but the person receiving it sees a warning or yesterday’s figures. A formula may read from another workbook that they cannot open. The number currently displayed is not proof that the source is reachable or has just been refreshed.
Find the dependency before sending
In current Excel for Windows, Microsoft describes Data → Queries and Connections → Workbook Links. Older interfaces may show Edit Links. Inspect the listed source and the relevant formulas. An external reference can also appear in defined names, chart titles or chart series, so a quick glance at visible cells is not a complete check.
For example, a packing summary may read quantities from a separate stock workbook. Decide whether the recipient needs a fixed list for today or a summary that will keep changing. Sending the summary alone does not supply the source file or give access to it.
Only enable external content when you trust the source. Removing a warning is not a reason to lower the general security settings.
Make the handover explicit
For a snapshot, preserve the editable original and prepare a separate copy with verified values. Breaking a workbook link replaces the formulas that use it with their current values. Microsoft warns that this cannot be undone in the desktop procedure; its web instructions allow undo. Keep a backup either way, and do not turn unverified cached numbers into an apparently final result.
Reopen the copy in a test context without access to the source, leaving the working files untouched. Compare key figures with your checked reference and inspect warnings. For an updating workbook instead, explain which source is needed, who should have access and how to refresh it. Label the handover with the date of the checked data, not a claim that it will always stay current.