Refresh the intended evidence without losing its history
Name the destination workbook and every source, decide whether to preserve or refresh cached values, verify authority, control broken links and settings, inspect changes and publish a provenance note.
Why this English matters now
Reading an external workbook links warning before updating data is a practical English, Excel external links, update links and spreadsheet data skill.
People searching Excel update links, unsafe links warning, workbook links or external data not updating need to identify the destination file, each source workbook, refresh scope and evidence state.
Strong readers preserve the before state, verify source ownership, avoid guessed replacements, distinguish refresh from recalculation and trace material changes before quoting a figure.
English matters because update, refresh, cached, broken, source and destination describe a data relationship. This article teaches careful reading, not a promise that every linked workbook is correct or safe.
Checked against the linked first-party sources on 30 October 2026. This educational guide explains how to read and write more precisely; it does not replace the organisation, programme owner, technology provider or government agency responsible for a live decision.
The destination-to-provenance route
Use this sequence before a live decision.
- Identify destination version and decision.
- List every source workbook and owner.
- Read cached, refresh and broken-link states.
- Update only verified sources through the approved route.
- Compare changes and publish refresh evidence and limits.
Official factual floor
These primary sources establish the current factual examples and should be reopened before a live application, update, citation or submission:
- Microsoft Support: manage workbook links
- Microsoft Support: workbook link management and storage
- MOE English Language Syllabus 2020
- IMDA Digital Skills for Life
- Microsoft says workbook links must be maintained and refreshed to retrieve latest source values.
- Microsoft documents Ask to refresh, Always refresh and Don't refresh settings.
- Microsoft distinguishes updating all links from choosing specific links through the Workbook Links pane.
Did you know?
Did You Know? A workbook may open with sensible numbers even when no live source was reached. Cached values can preserve a useful snapshot, but only a refresh record tells the reader what state the figure represents.
Full chapter index
- 1. Identify the destination workbook
- 2. Locate every linked source
- 3. Distinguish current values from refreshed values
- 4. Read Update and Don't Update as evidence choices
- 5. Verify source ownership and authority
- 6. Handle broken links without inventing a replacement
- 7. Separate refreshing from recalculating
- 8. Control automatic-refresh settings
- 9. Treat security warnings separately
- 10. Compare the values that changed
- 11. Prepare an offline or unavailable-source plan
- 12. Publish a provenance note
How workbook links move values
Workbook links bring values from source workbooks into a destination workbook. Name the file you opened and the decision it supports before refreshing anything.
A destination can depend on several sources. This extra pass matters because a short label often compresses several decisions: who the information applies to, which version is current, what condition must be met and what action follows. English becomes useful when those relationships remain visible instead of being flattened into a vague impression.
A group-report refresh
Example: A student updates links in a copied report rather than the version used for submission.
The mistake is understandable, but it changes the decision. A careful reader returns to the authoritative page, copies the exact governing words, checks the date and scope, and writes a short note that separates what the source says from what the reader infers. That note makes later discussion calmer because everyone can inspect the same evidence.
- 1. name destination file
- 2. check path and version
- 3. state the task
- 4. save a controlled copy if permitted
After the four moves, explain the result in one complete sentence. Include the document or page, the relevant state, the condition and the next action. If the sentence sounds more certain than the source, narrow it. If it is too vague to guide a responsible action, return to the source and locate the missing qualifier.
What Update cannot prove
Object identification supports research and finance.
For a student, the transfer may appear in an assignment, application or group project. For a parent, it may shape a deadline or consent decision. For a teacher, adviser or manager, it may determine whether a question can be answered from the record or must be routed to the issuing body. The shared habit is simple: preserve source, version, scope and action together.
How workbook links move values
A destination can contain more than one workbook link. Read the list, source path and status instead of assuming one banner refers to one file.
Cached values may look current. This extra pass matters because a short label often compresses several decisions: who the information applies to, which version is current, what condition must be met and what action follows. English becomes useful when those relationships remain visible instead of being flattened into a vague impression.
A group-report refresh
Example: A report refreshes three sources, but the group has verified only one.
The mistake is understandable, but it changes the decision. A careful reader returns to the authoritative page, copies the exact governing words, checks the date and scope, and writes a short note that separates what the source says from what the reader infers. That note makes later discussion calmer because everyone can inspect the same evidence.
- 1. open the Workbook Links pane
- 2. list sources
- 3. mark owners and locations
- 4. flag unknown links
After the four moves, explain the result in one complete sentence. Include the document or page, the relevant state, the condition and the next action. If the sentence sounds more certain than the source, narrow it. If it is too vague to guide a responsible action, return to the source and locate the missing qualifier.
What Update cannot prove
Dependency mapping supports projects and code.
For a student, the transfer may appear in an assignment, application or group project. For a parent, it may shape a deadline or consent decision. For a teacher, adviser or manager, it may determine whether a question can be answered from the record or must be routed to the issuing body. The shared habit is simple: preserve source, version, scope and action together.
How workbook links move values
A workbook can show cached values from an earlier save while linked sources have changed. Current-looking numbers are not necessarily freshly retrieved numbers.
Refresh and recalculation are separate. This extra pass matters because a short label often compresses several decisions: who the information applies to, which version is current, what condition must be met and what action follows. English becomes useful when those relationships remain visible instead of being flattened into a vague impression.
A group-report refresh
Example: A dashboard opens with plausible totals and is quoted before the refresh state is checked.
The mistake is understandable, but it changes the decision. A careful reader returns to the authoritative page, copies the exact governing words, checks the date and scope, and writes a short note that separates what the source says from what the reader infers. That note makes later discussion calmer because everyone can inspect the same evidence.
- 1. read last-known context
- 2. check refresh setting
- 3. record refresh time
- 4. label stale values if used
After the four moves, explain the result in one complete sentence. Include the document or page, the relevant state, the condition and the next action. If the sentence sounds more certain than the source, narrow it. If it is too vague to guide a responsible action, return to the source and locate the missing qualifier.
What Update cannot prove
Data-state language supports charts and reports.
For a student, the transfer may appear in an assignment, application or group project. For a parent, it may shape a deadline or consent decision. For a teacher, adviser or manager, it may determine whether a question can be answered from the record or must be routed to the issuing body. The shared habit is simple: preserve source, version, scope and action together.
How workbook links move values
Microsoft documents an unsafe-links warning that can update all links or leave current displayed values. Each choice changes what evidence the workbook contains.
A successful update does not validate the data. This extra pass matters because a short label often compresses several decisions: who the information applies to, which version is current, what condition must be met and what action follows. English becomes useful when those relationships remain visible instead of being flattened into a vague impression.
A group-report refresh
Example: A student selects Update reflexively, then cannot reproduce the earlier figures used in a draft.
The mistake is understandable, but it changes the decision. A careful reader returns to the authoritative page, copies the exact governing words, checks the date and scope, and writes a short note that separates what the source says from what the reader infers. That note makes later discussion calmer because everyone can inspect the same evidence.
- 1. state what must be preserved
- 2. verify sources
- 3. choose update scope
- 4. record before-and-after values
After the four moves, explain the result in one complete sentence. Include the document or page, the relevant state, the condition and the next action. If the sentence sounds more certain than the source, narrow it. If it is too vague to guide a responsible action, return to the source and locate the missing qualifier.
What Update cannot prove
Choice-consequence reading supports examinations and work.
For a student, the transfer may appear in an assignment, application or group project. For a parent, it may shape a deadline or consent decision. For a teacher, adviser or manager, it may determine whether a question can be answered from the record or must be routed to the issuing body. The shared habit is simple: preserve source, version, scope and action together.
How workbook links move values
A broken source can result from movement, renaming or lost access. Use the documented owner or project record to locate the intended source.
Cached values may look current. This extra pass matters because a short label often compresses several decisions: who the information applies to, which version is current, what condition must be met and what action follows. English becomes useful when those relationships remain visible instead of being flattened into a vague impression.
A group-report refresh
Example: Excel requests a source and the learner chooses a similarly named file from Downloads.
The mistake is understandable, but it changes the decision. A careful reader returns to the authoritative page, copies the exact governing words, checks the date and scope, and writes a short note that separates what the source says from what the reader infers. That note makes later discussion calmer because everyone can inspect the same evidence.
- 1. copy the broken path
- 2. identify expected source
- 3. ask the owner
- 4. test on a controlled copy
After the four moves, explain the result in one complete sentence. Include the document or page, the relevant state, the condition and the next action. If the sentence sounds more certain than the source, narrow it. If it is too vague to guide a responsible action, return to the source and locate the missing qualifier.
What Update cannot prove
Recovery discipline supports datasets and citations.
For a student, the transfer may appear in an assignment, application or group project. For a parent, it may shape a deadline or consent decision. For a teacher, adviser or manager, it may determine whether a question can be answered from the record or must be routed to the issuing body. The shared habit is simple: preserve source, version, scope and action together.
How workbook links move values
Refreshing links retrieves source values, while formula recalculation applies workbook logic. The steps are related but not identical.
Refresh and recalculation are separate. This extra pass matters because a short label often compresses several decisions: who the information applies to, which version is current, what condition must be met and what action follows. English becomes useful when those relationships remain visible instead of being flattened into a vague impression.
A group-report refresh
Example: New source values arrive but a manual-calculation workbook still shows an old derived total.
The mistake is understandable, but it changes the decision. A careful reader returns to the authoritative page, copies the exact governing words, checks the date and scope, and writes a short note that separates what the source says from what the reader infers. That note makes later discussion calmer because everyone can inspect the same evidence.
- 1. check refresh result
- 2. check calculation mode
- 3. recalculate through the approved process
- 4. verify key outputs
After the four moves, explain the result in one complete sentence. Include the document or page, the relevant state, the condition and the next action. If the sentence sounds more certain than the source, narrow it. If it is too vague to guide a responsible action, return to the source and locate the missing qualifier.
What Update cannot prove
Process decomposition supports mathematics and analytics.
For a student, the transfer may appear in an assignment, application or group project. For a parent, it may shape a deadline or consent decision. For a teacher, adviser or manager, it may determine whether a question can be answered from the record or must be routed to the issuing body. The shared habit is simple: preserve source, version, scope and action together.
How workbook links move values
Microsoft documents Ask to refresh, Always refresh and Don't refresh options. The setting can affect all users of the workbook, so it belongs to workbook governance, not personal convenience alone.
A successful update does not validate the data. This extra pass matters because a short label often compresses several decisions: who the information applies to, which version is current, what condition must be met and what action follows. English becomes useful when those relationships remain visible instead of being flattened into a vague impression.
A group-report refresh
Example: One student suppresses the prompt and classmates no longer know the data is old.
The mistake is understandable, but it changes the decision. A careful reader returns to the authoritative page, copies the exact governing words, checks the date and scope, and writes a short note that separates what the source says from what the reader infers. That note makes later discussion calmer because everyone can inspect the same evidence.
- 1. read the current setting
- 2. identify workbook owner
- 3. choose through team policy
- 4. document the decision
After the four moves, explain the result in one complete sentence. Include the document or page, the relevant state, the condition and the next action. If the sentence sounds more certain than the source, narrow it. If it is too vague to guide a responsible action, return to the source and locate the missing qualifier.
What Update cannot prove
Shared-setting literacy supports collaboration.
For a student, the transfer may appear in an assignment, application or group project. For a parent, it may shape a deadline or consent decision. For a teacher, adviser or manager, it may determine whether a question can be answered from the record or must be routed to the issuing body. The shared habit is simple: preserve source, version, scope and action together.
How workbook links move values
A Security Warning bar can concern trust and active external content, while a workbook-link prompt concerns data retrieval. Read every warning rather than treating one click as approval for all layers.
A destination can depend on several sources. This extra pass matters because a short label often compresses several decisions: who the information applies to, which version is current, what condition must be met and what action follows. English becomes useful when those relationships remain visible instead of being flattened into a vague impression.
A group-report refresh
Example: A workbook updates links after content is enabled, and the user assumes all sources are safe.
The mistake is understandable, but it changes the decision. A careful reader returns to the authoritative page, copies the exact governing words, checks the date and scope, and writes a short note that separates what the source says from what the reader infers. That note makes later discussion calmer because everyone can inspect the same evidence.
- 1. name each warning
- 2. verify source and file
- 3. enable only authorised content
- 4. record what changed
After the four moves, explain the result in one complete sentence. Include the document or page, the relevant state, the condition and the next action. If the sentence sounds more certain than the source, narrow it. If it is too vague to guide a responsible action, return to the source and locate the missing qualifier.
What Update cannot prove
Layered consent supports digital safety.
For a student, the transfer may appear in an assignment, application or group project. For a parent, it may shape a deadline or consent decision. For a teacher, adviser or manager, it may determine whether a question can be answered from the record or must be routed to the issuing body. The shared habit is simple: preserve source, version, scope and action together.
How workbook links move values
After an authorised refresh, inspect material differences and trace them to source changes, dates, units or definitions. A refresh is an event; interpretation is a separate reasoning task.
Cached values may look current. This extra pass matters because a short label often compresses several decisions: who the information applies to, which version is current, what condition must be met and what action follows. English becomes useful when those relationships remain visible instead of being flattened into a vague impression.
A group-report refresh
Example: A percentage rises because the denominator changed, not because performance improved.
The mistake is understandable, but it changes the decision. A careful reader returns to the authoritative page, copies the exact governing words, checks the date and scope, and writes a short note that separates what the source says from what the reader infers. That note makes later discussion calmer because everyone can inspect the same evidence.
- 1. capture before values
- 2. capture after values
- 3. trace source row
- 4. explain unit and period
After the four moves, explain the result in one complete sentence. Include the document or page, the relevant state, the condition and the next action. If the sentence sounds more certain than the source, narrow it. If it is too vague to guide a responsible action, return to the source and locate the missing qualifier.
What Update cannot prove
Change analysis supports science and careers.
For a student, the transfer may appear in an assignment, application or group project. For a parent, it may shape a deadline or consent decision. For a teacher, adviser or manager, it may determine whether a question can be answered from the record or must be routed to the issuing body. The shared habit is simple: preserve source, version, scope and action together.
How workbook links move values
A defensible output records destination version, linked source, refresh date, transformation and known failures. This lets another reader reproduce or challenge the figure.
A successful update does not validate the data. This extra pass matters because a short label often compresses several decisions: who the information applies to, which version is current, what condition must be met and what action follows. English becomes useful when those relationships remain visible instead of being flattened into a vague impression.
A group-report refresh
Example: A chart is pasted into a report with no source-workbook or refresh information.
The mistake is understandable, but it changes the decision. A careful reader returns to the authoritative page, copies the exact governing words, checks the date and scope, and writes a short note that separates what the source says from what the reader infers. That note makes later discussion calmer because everyone can inspect the same evidence.
- 1. name destination
- 2. name sources
- 3. record refresh status
- 4. record limitations
After the four moves, explain the result in one complete sentence. Include the document or page, the relevant state, the condition and the next action. If the sentence sounds more certain than the source, narrow it. If it is too vague to guide a responsible action, return to the source and locate the missing qualifier.
What Update cannot prove
Traceable data strengthens school and workplace decisions.
For a student, the transfer may appear in an assignment, application or group project. For a parent, it may shape a deadline or consent decision. For a teacher, adviser or manager, it may determine whether a question can be answered from the record or must be routed to the issuing body. The shared habit is simple: preserve source, version, scope and action together.
Four discoveries inside workbook links
Files have roles
Destination and source are not interchangeable.
Use it: Name each file.
Visible can be cached
Opening is not refreshing.
Use it: Check state.
Settings affect others
Refresh behaviour can be shared.
Use it: Use authority.
Change needs explanation
A new value needs provenance.
Use it: Trace the source.
Workbook-link evidence lab
Dependency map
Draw destination and source relationships.
- destination
- source
- owner
- status
Before-and-after note
Record what an authorised refresh changes.
- value
- time
- unit
- source
Broken-link report
Describe a failure without guessing.
- path
- expected source
- error
- owner
Advice for students, families and educators
For students
- Keep a controlled copy before an authorised refresh.
- Do not select a similarly named replacement by guesswork.
For families and mentors
- Ask which source owns the number.
- Encourage a refresh date beside charts.
For educators and workplaces
- Publish source ownership and refresh rules.
- Separate security warnings from data-update instructions.
Frequently asked questions
What is a workbook link?
A relationship in which a destination workbook retrieves values from a source workbook.
Are displayed values current?
Not necessarily; they may be cached.
What does Update do?
It refreshes linked data according to the selected scope and current configuration.
Should I update unknown links?
No; verify the source first.
What if a link is broken?
Use the owner or project record to locate the intended source.
Is refresh the same as recalculation?
No.
Can I suppress the prompt?
Only through the workbook owner's approved setting decision.
Does a successful refresh prove accuracy?
No.
What belongs in provenance?
Destination, sources, refresh state, time, transformation and limits.
Why English?
Because relationship and state words determine what the number means.
Useful next reading
- Dashboard Refresh Note — interpret published refresh timing
- Data Dictionary — check fields and units
- Source Credibility — verify the data owner
Closing thought
A linked workbook becomes defensible when the reader can name every file, state whether values are cached or refreshed, explain changes and lead another reader back to the source.