A displayed number can be perfectly formatted and still be stale; verify when the workbook actually recalculates before using its result
Use a workbook-purpose–calculation-mode–open-workbook-scope–dependency–data-table–external-link–volatile-function–manual-command–iteration–precision–expected-case–saved-state–reopen–decision chain. Separate when Excel recalculates from whether the formula, data and judgement are valid.
Why this English matters now
Reading Excel’s Calculation Options before trusting workbook results is practical English for students, teachers and analysts searching why Excel formulas are not updating, how to turn on automatic calculation or what manual calculation means.
Microsoft’s current guidance says Automatic recalculates dependent formulas after relevant changes, Partial recalculates dependent formulas except data tables and Manual updates formulas only when the user recalculates. Microsoft also warns that, in desktop Excel, changing these options affects all open workbooks.
Calculation mode is a state, not a measure of correctness. Strong reviewers preserve the workbook, record the current mode, identify data tables and links, calculate deliberately, compare expected and edge cases, verify saved values and reopen the exact file before a result supports a grade, report, plan or decision.
Checked against the linked first-party sources on 30 October 2026. Interfaces, managed-device rules and school procedures can change, so reopen the current source before a live assessment, disclosure or account decision.
The practical reading method
Use a workbook-purpose–calculation-mode–open-workbook-scope–dependency–data-table–external-link–volatile-function–manual-command–iteration–precision–expected-case–saved-state–reopen–decision chain. Separate when Excel recalculates from whether the formula, data and judgement are valid.
- Microsoft says Automatic is the default and recalculates dependent formulas after changes.
- Microsoft says Partial recalculates dependent formulas except data tables.
- Microsoft says Manual turns off automatic recalculation and formulas update when manually recalculated, such as with F9.
- Microsoft warns that calculation-option changes in Excel desktop affect all open workbooks.
Official factual floor
- Microsoft Support: Change formula recalculation, iteration, or precision in Excel
- Microsoft Support: Excel calculation process
- MOE English Language Syllabus 2020
- IMDA Digital Skills for Life
- Microsoft says Automatic recalculates dependent formulas when a value, formula or name changes.
- Microsoft says Partial excludes data tables from automatic recalculation, while Manual waits for a manual recalculation command.
- Microsoft says desktop calculation-option changes affect all open workbooks and Manual selects Recalculate workbook before saving by default.
Did You Know?
A workbook opened while another workbook is already in Manual mode can be viewed in that shared desktop calculation environment. The visible result may therefore reflect an earlier calculation even though the formula itself has not changed.
Full chapter index
- 1. Define the workbook decision
- 2. Preserve the workbook and environment
- 3. Read Automatic correctly
- 4. Read Partial and data-table exceptions
- 5. Read Manual without panic
- 6. Understand the all-open-workbooks scope
- 7. Distinguish Calculate Now and Calculate Sheet
- 8. Inspect external links
- 9. Identify volatile and expensive formulas
- 10. Treat iteration and circular references separately
- 11. Separate stored value from displayed precision
- 12. Test normal, boundary and stale cases
- 13. Verify the exact saved workbook
The mechanism
Result freshness matters only in relation to a named output and user.
Microsoft says Automatic is the default and recalculates dependent formulas after changes. In this chapter, the decisive phrase is define the workbook decision. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: A status dashboard is trusted without stating which cells drive a deadline decision.
Calculation Options control when Excel recomputes formulas. They do not prove formulas are correct, inputs are current, data tables have recalculated, links are trustworthy, displayed precision matches stored values, iteration is justified or a workbook is fit for a decision.
- 1. name the output
- 2. state the user
- 3. state acceptable delay
- 4. identify accountable review
Preserve a controlled copy; define workbook purpose and outputs; record all open workbooks and the calculation mode; identify data tables, external links, volatile functions, circular references and iteration settings; enter a controlled input; calculate the intended scope; compare expected values and timestamps; inspect errors; save, close all related workbooks, reopen the exact file in a known mode, recalculate and verify the final values before use. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Record workbook version, purpose, open workbooks, calculation mode, data-table presence, links, volatile functions, iteration and precision settings, input change, Calculate Now or Calculate Sheet command, before-and-after outputs, expected cases, saved state, reopen result, reviewer and final file identity.
Transfer: Purpose language supports spreadsheet judgement. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
Calculation mode can interact with other open workbooks and later saves.
Microsoft says Partial recalculates dependent formulas except data tables. In this chapter, the decisive phrase is preserve the workbook and environment. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: A shared model is opened beside a manual-calculation workbook and silently saved.
Calculation Options control when Excel recomputes formulas. They do not prove formulas are correct, inputs are current, data tables have recalculated, links are trustworthy, displayed precision matches stored values, iteration is justified or a workbook is fit for a decision.
- 1. save a controlled copy
- 2. list open workbooks
- 3. record the mode
- 4. protect sensitive data
Preserve a controlled copy; define workbook purpose and outputs; record all open workbooks and the calculation mode; identify data tables, external links, volatile functions, circular references and iteration settings; enter a controlled input; calculate the intended scope; compare expected values and timestamps; inspect errors; save, close all related workbooks, reopen the exact file in a known mode, recalculate and verify the final values before use. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Record workbook version, purpose, open workbooks, calculation mode, data-table presence, links, volatile functions, iteration and precision settings, input change, Calculate Now or Calculate Sheet command, before-and-after outputs, expected cases, saved state, reopen result, reviewer and final file identity.
Transfer: Environment language supports reproducibility. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
Automatic recalculates dependent formulas after relevant changes.
Microsoft says Manual turns off automatic recalculation and formulas update when manually recalculated, such as with F9. In this chapter, the decisive phrase is read automatic correctly. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: Automatic is described as proof that every value is current and correct.
Calculation Options control when Excel recomputes formulas. They do not prove formulas are correct, inputs are current, data tables have recalculated, links are trustworthy, displayed precision matches stored values, iteration is justified or a workbook is fit for a decision.
- 1. confirm Automatic
- 2. change one controlled input
- 3. observe dependents
- 4. compare a known result
Preserve a controlled copy; define workbook purpose and outputs; record all open workbooks and the calculation mode; identify data tables, external links, volatile functions, circular references and iteration settings; enter a controlled input; calculate the intended scope; compare expected values and timestamps; inspect errors; save, close all related workbooks, reopen the exact file in a known mode, recalculate and verify the final values before use. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Record workbook version, purpose, open workbooks, calculation mode, data-table presence, links, volatile functions, iteration and precision settings, input change, Calculate Now or Calculate Sheet command, before-and-after outputs, expected cases, saved state, reopen result, reviewer and final file identity.
Transfer: State language supports accurate reporting. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
Microsoft says Partial recalculates dependent formulas except data tables.
Microsoft warns that calculation-option changes in Excel desktop affect all open workbooks. In this chapter, the decisive phrase is read partial and data-table exceptions. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: A sensitivity table is assumed to refresh with the rest of the workbook.
Calculation Options control when Excel recomputes formulas. They do not prove formulas are correct, inputs are current, data tables have recalculated, links are trustworthy, displayed precision matches stored values, iteration is justified or a workbook is fit for a decision.
- 1. identify data tables
- 2. record Partial mode
- 3. calculate the required scope
- 4. compare known table cells
Preserve a controlled copy; define workbook purpose and outputs; record all open workbooks and the calculation mode; identify data tables, external links, volatile functions, circular references and iteration settings; enter a controlled input; calculate the intended scope; compare expected values and timestamps; inspect errors; save, close all related workbooks, reopen the exact file in a known mode, recalculate and verify the final values before use. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Record workbook version, purpose, open workbooks, calculation mode, data-table presence, links, volatile functions, iteration and precision settings, input change, Calculate Now or Calculate Sheet command, before-and-after outputs, expected cases, saved state, reopen result, reviewer and final file identity.
Transfer: Exception language supports model review. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
Manual mode can be deliberate in large workbooks but requires explicit recalculation discipline.
Microsoft says Automatic is the default and recalculates dependent formulas after changes. In this chapter, the decisive phrase is read manual without panic. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: A slow model is switched to Manual and users are not told that displayed values can be stale.
Calculation Options control when Excel recomputes formulas. They do not prove formulas are correct, inputs are current, data tables have recalculated, links are trustworthy, displayed precision matches stored values, iteration is justified or a workbook is fit for a decision.
- 1. state why Manual is used
- 2. show a visible status note
- 3. define recalculation steps
- 4. train every collaborator
Preserve a controlled copy; define workbook purpose and outputs; record all open workbooks and the calculation mode; identify data tables, external links, volatile functions, circular references and iteration settings; enter a controlled input; calculate the intended scope; compare expected values and timestamps; inspect errors; save, close all related workbooks, reopen the exact file in a known mode, recalculate and verify the final values before use. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Record workbook version, purpose, open workbooks, calculation mode, data-table presence, links, volatile functions, iteration and precision settings, input change, Calculate Now or Calculate Sheet command, before-and-after outputs, expected cases, saved state, reopen result, reviewer and final file identity.
Transfer: Procedure language supports teamwork. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
Microsoft says desktop option changes affect all open workbooks.
Microsoft says Partial recalculates dependent formulas except data tables. In this chapter, the decisive phrase is understand the all-open-workbooks scope. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: A learner changes one workbook to Manual and assumes another open workbook remains Automatic.
Calculation Options control when Excel recomputes formulas. They do not prove formulas are correct, inputs are current, data tables have recalculated, links are trustworthy, displayed precision matches stored values, iteration is justified or a workbook is fit for a decision.
- 1. close unrelated files
- 2. record the mode change
- 3. recheck every open workbook
- 4. restore the intended state
Preserve a controlled copy; define workbook purpose and outputs; record all open workbooks and the calculation mode; identify data tables, external links, volatile functions, circular references and iteration settings; enter a controlled input; calculate the intended scope; compare expected values and timestamps; inspect errors; save, close all related workbooks, reopen the exact file in a known mode, recalculate and verify the final values before use. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Record workbook version, purpose, open workbooks, calculation mode, data-table presence, links, volatile functions, iteration and precision settings, input change, Calculate Now or Calculate Sheet command, before-and-after outputs, expected cases, saved state, reopen result, reviewer and final file identity.
Transfer: Scope language supports safe work. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
Different commands recalculate different scopes.
Microsoft says Manual turns off automatic recalculation and formulas update when manually recalculated, such as with F9. In this chapter, the decisive phrase is distinguish calculate now and calculate sheet. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: The active sheet is calculated while a dependent input sheet remains stale.
Calculation Options control when Excel recomputes formulas. They do not prove formulas are correct, inputs are current, data tables have recalculated, links are trustworthy, displayed precision matches stored values, iteration is justified or a workbook is fit for a decision.
- 1. name the intended scope
- 2. use Calculate Now for all open worksheets when needed
- 3. use Calculate Sheet deliberately
- 4. compare dependency results
Preserve a controlled copy; define workbook purpose and outputs; record all open workbooks and the calculation mode; identify data tables, external links, volatile functions, circular references and iteration settings; enter a controlled input; calculate the intended scope; compare expected values and timestamps; inspect errors; save, close all related workbooks, reopen the exact file in a known mode, recalculate and verify the final values before use. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Record workbook version, purpose, open workbooks, calculation mode, data-table presence, links, volatile functions, iteration and precision settings, input change, Calculate Now or Calculate Sheet command, before-and-after outputs, expected cases, saved state, reopen result, reviewer and final file identity.
Transfer: Command language supports control. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
Linked workbooks can supply stored values that are not fully recalculated.
Microsoft warns that calculation-option changes in Excel desktop affect all open workbooks. In this chapter, the decisive phrase is inspect external links. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: A source workbook warning is dismissed and the imported value is treated as current.
Calculation Options control when Excel recomputes formulas. They do not prove formulas are correct, inputs are current, data tables have recalculated, links are trustworthy, displayed precision matches stored values, iteration is justified or a workbook is fit for a decision.
- 1. list link sources
- 2. verify access and date
- 3. open authorised sources
- 4. record update choices
Preserve a controlled copy; define workbook purpose and outputs; record all open workbooks and the calculation mode; identify data tables, external links, volatile functions, circular references and iteration settings; enter a controlled input; calculate the intended scope; compare expected values and timestamps; inspect errors; save, close all related workbooks, reopen the exact file in a known mode, recalculate and verify the final values before use. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Record workbook version, purpose, open workbooks, calculation mode, data-table presence, links, volatile functions, iteration and precision settings, input change, Calculate Now or Calculate Sheet command, before-and-after outputs, expected cases, saved state, reopen result, reviewer and final file identity.
Transfer: Source language supports evidence. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
Some functions and data structures recalculate frequently and can affect performance.
Microsoft says Automatic is the default and recalculates dependent formulas after changes. In this chapter, the decisive phrase is identify volatile and expensive formulas. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: Slow calculation is solved by disabling updates without finding the expensive region.
Calculation Options control when Excel recomputes formulas. They do not prove formulas are correct, inputs are current, data tables have recalculated, links are trustworthy, displayed precision matches stored values, iteration is justified or a workbook is fit for a decision.
- 1. profile slow sheets
- 2. identify volatile functions
- 3. review whole-column references
- 4. optimise with evidence
Preserve a controlled copy; define workbook purpose and outputs; record all open workbooks and the calculation mode; identify data tables, external links, volatile functions, circular references and iteration settings; enter a controlled input; calculate the intended scope; compare expected values and timestamps; inspect errors; save, close all related workbooks, reopen the exact file in a known mode, recalculate and verify the final values before use. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Record workbook version, purpose, open workbooks, calculation mode, data-table presence, links, volatile functions, iteration and precision settings, input change, Calculate Now or Calculate Sheet command, before-and-after outputs, expected cases, saved state, reopen result, reviewer and final file identity.
Transfer: Performance language supports engineering. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
Iterative calculation repeatedly recalculates circular formulas under defined limits.
Microsoft says Partial recalculates dependent formulas except data tables. In this chapter, the decisive phrase is treat iteration and circular references separately. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: Iteration is enabled merely to hide a circular-reference warning.
Calculation Options control when Excel recomputes formulas. They do not prove formulas are correct, inputs are current, data tables have recalculated, links are trustworthy, displayed precision matches stored values, iteration is justified or a workbook is fit for a decision.
- 1. find the circular path
- 2. justify the model
- 3. record maximum iterations
- 4. test convergence
Preserve a controlled copy; define workbook purpose and outputs; record all open workbooks and the calculation mode; identify data tables, external links, volatile functions, circular references and iteration settings; enter a controlled input; calculate the intended scope; compare expected values and timestamps; inspect errors; save, close all related workbooks, reopen the exact file in a known mode, recalculate and verify the final values before use. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Record workbook version, purpose, open workbooks, calculation mode, data-table presence, links, volatile functions, iteration and precision settings, input change, Calculate Now or Calculate Sheet command, before-and-after outputs, expected cases, saved state, reopen result, reviewer and final file identity.
Transfer: Iteration language supports mathematics. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
Formatting, stored precision and precision-as-displayed are different choices.
Microsoft says Manual turns off automatic recalculation and formulas update when manually recalculated, such as with F9. In this chapter, the decisive phrase is separate stored value from displayed precision. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: A rounded display is reported as though the stored value changed.
Calculation Options control when Excel recomputes formulas. They do not prove formulas are correct, inputs are current, data tables have recalculated, links are trustworthy, displayed precision matches stored values, iteration is justified or a workbook is fit for a decision.
- 1. inspect the formula result
- 2. inspect number format
- 3. record precision settings
- 4. avoid irreversible changes without review
Preserve a controlled copy; define workbook purpose and outputs; record all open workbooks and the calculation mode; identify data tables, external links, volatile functions, circular references and iteration settings; enter a controlled input; calculate the intended scope; compare expected values and timestamps; inspect errors; save, close all related workbooks, reopen the exact file in a known mode, recalculate and verify the final values before use. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Record workbook version, purpose, open workbooks, calculation mode, data-table presence, links, volatile functions, iteration and precision settings, input change, Calculate Now or Calculate Sheet command, before-and-after outputs, expected cases, saved state, reopen result, reviewer and final file identity.
Transfer: Precision language supports quantitative work. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
Known cases reveal whether recalculation and logic respond as expected.
Microsoft warns that calculation-option changes in Excel desktop affect all open workbooks. In this chapter, the decisive phrase is test normal, boundary and stale cases. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: Only the current happy-path inputs are checked.
Calculation Options control when Excel recomputes formulas. They do not prove formulas are correct, inputs are current, data tables have recalculated, links are trustworthy, displayed precision matches stored values, iteration is justified or a workbook is fit for a decision.
- 1. choose a simple known case
- 2. test a boundary
- 3. change one dependency
- 4. compare before and after calculation
Preserve a controlled copy; define workbook purpose and outputs; record all open workbooks and the calculation mode; identify data tables, external links, volatile functions, circular references and iteration settings; enter a controlled input; calculate the intended scope; compare expected values and timestamps; inspect errors; save, close all related workbooks, reopen the exact file in a known mode, recalculate and verify the final values before use. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Record workbook version, purpose, open workbooks, calculation mode, data-table presence, links, volatile functions, iteration and precision settings, input change, Calculate Now or Calculate Sheet command, before-and-after outputs, expected cases, saved state, reopen result, reviewer and final file identity.
Transfer: Case language supports verification. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
A recalculated window and a saved file are not the same artefact.
Microsoft says Automatic is the default and recalculates dependent formulas after changes. In this chapter, the decisive phrase is verify the exact saved workbook. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: Correct values are visible but an earlier file is uploaded.
Calculation Options control when Excel recomputes formulas. They do not prove formulas are correct, inputs are current, data tables have recalculated, links are trustworthy, displayed precision matches stored values, iteration is justified or a workbook is fit for a decision.
- 1. save close and reopen
- 2. confirm the mode
- 3. recalculate once more
- 4. open the actual attachment or upload
Preserve a controlled copy; define workbook purpose and outputs; record all open workbooks and the calculation mode; identify data tables, external links, volatile functions, circular references and iteration settings; enter a controlled input; calculate the intended scope; compare expected values and timestamps; inspect errors; save, close all related workbooks, reopen the exact file in a known mode, recalculate and verify the final values before use. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Record workbook version, purpose, open workbooks, calculation mode, data-table presence, links, volatile functions, iteration and precision settings, input change, Calculate Now or Calculate Sheet command, before-and-after outputs, expected cases, saved state, reopen result, reviewer and final file identity.
Transfer: Release verification supports education and careers. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
Four useful discoveries
Define the workbook decision
Result freshness matters only in relation to a named output and user.
Boundary: A fresh number can still support a poor decision.
Preserve the workbook and environment
Calculation mode can interact with other open workbooks and later saves.
Boundary: A copied workbook can still depend on external sources.
Read Automatic correctly
Automatic recalculates dependent formulas after relevant changes.
Boundary: Automatic cannot repair wrong dependencies or stale source data.
Read Partial and data-table exceptions
Microsoft says Partial recalculates dependent formulas except data tables.
Boundary: A data table is different from an ordinary Excel table.
Practice with realistic decisions
Read Manual without panic
A slow model is switched to Manual and users are not told that displayed values can be stale.
- state why Manual is used
- show a visible status note
- define recalculation steps
- train every collaborator
Understand the all-open-workbooks scope
A learner changes one workbook to Manual and assumes another open workbook remains Automatic.
- close unrelated files
- record the mode change
- recheck every open workbook
- restore the intended state
Distinguish Calculate Now and Calculate Sheet
The active sheet is calculated while a dependent input sheet remains stale.
- name the intended scope
- use Calculate Now for all open worksheets when needed
- use Calculate Sheet deliberately
- compare dependency results
Advice for students, families and educators
For students
- Record the calculation mode before troubleshooting formulas that seem not to update.
- Use a tiny known input to prove that the intended dependents change.
For families
- Ask what the number depends on and when it was last recalculated rather than editing the learner’s model.
- Keep personal or school data out of demonstration copies.
For educators
- Include one deliberately stale workbook in spreadsheet review practice.
- Assess the student’s mode, scope and test evidence—not only the final displayed value.
Frequently asked questions
What does Automatic do?
It recalculates dependent formulas after relevant changes.
What does Partial do?
Microsoft says it recalculates dependent formulas except data tables.
What does Manual do?
It waits for a manual recalculation command.
Does changing the mode affect only one workbook?
Microsoft warns that desktop changes affect all open workbooks.
What does F9 do?
It is a documented route for manual recalculation; verify the intended scope and platform.
Are displayed values always current?
No.
Does recalculation prove a formula is correct?
No.
What about circular references?
Treat iteration as a separate, justified model setting.
What should I verify?
Mode, scope, tables, links, test cases, saved state and exact workbook.
Why English?
Because automatic, partial, manual, dependent, current, stored and displayed describe different states.
Useful next reading
- Excel Data Table results — verify the data-table exception and sensitivity outputs
- Excel Show Formulas — inspect the sheet-wide formula pattern
- Why English Matters in Singapore — connect precise spreadsheet language to study and work
Closing thought
Trust begins by knowing whether a number is fresh. Read the mode, calculate the right scope, challenge the workbook with known cases and reopen the real file before its polished result becomes evidence.