eduKate Singapore

VIEW THIS AS

Auto mode follows the Route Engine until you choose a viewpoint.

YOU ARE HERE

ROUTE CHECK

CONNECTED TO

WHAT NEXT

Use the canonical route for this room, or HELP if you are unsure.

Next useful routeCanonical hubHELP

Why English? | Reading Excel’s Workbook Analysis Report Before Documenting Spreadsheet Risk

—

by

eduKate Asia
EXCEL · SPREADSHEET INQUIRE · WORKBOOK RISK

Translate a technical inventory into specific review questions without treating counts or warnings as automatic proof of error

Use a purpose–subject-file–edition–add-in–analysis-category–item–business-impact–corroboration–finding–owner–remediation–release chain. Treat Workbook Analysis as an inventory and navigation aid, not an audit opinion.

ROUTE 1OrientDefine the workbook’s decision purposeROUTE 2InterpretRun and time Workbook AnalysisROUTE 3ControlRead Formula detailsROUTE 4VerifyInterpret Warnings

Open the full chapter index ↓

Why this English matters now

Reading Excel’s Workbook Analysis report before documenting spreadsheet risk is practical English for students, analysts, auditors and office teams searching how to analyse an Excel workbook, use Spreadsheet Inquire or document formula and link risks.

Microsoft’s current guidance says Spreadsheet Inquire is available only in Excel for Windows in Microsoft 365 Apps for enterprise plans and equivalent editions, and an administrator may make it unavailable. After the Inquire add-in is enabled, Inquire > Workbook Analysis produces categories for Summary, Workbook, Formulas, Cells, Ranges and Warnings. Reviewers can select a category for worksheet, cell, range, connection, formula or error detail and export the analysis data to another workbook.

A large count is not automatically dangerous and a small workbook is not automatically safe. Strong reviewers preserve the subject file, define the decision it supports, confirm that the available edition and add-in apply, save when prompted, read category definitions, trace critical formulas and connections, distinguish inventory from judgement, sample warnings in context, protect exported analysis data, document material findings, use independent recalculation or comparison when needed and verify the exact workbook approved for use.

Checked against the linked first-party sources on 2 November 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 purpose–subject-file–edition–add-in–analysis-category–item–business-impact–corroboration–finding–owner–remediation–release chain. Treat Workbook Analysis as an inventory and navigation aid, not an audit opinion.

  1. Microsoft limits Spreadsheet Inquire to Excel for Windows in Microsoft 365 Apps for enterprise plans and equivalent editions.
  2. Microsoft describes Workbook Analysis as a comprehensive view of logic structure and error status that can support assessment of potential risk and impact.
  3. Microsoft groups results into Summary, Workbook, Formulas, Cells, Ranges and Warnings, with selectable detail for locations and relationships.
  4. Microsoft allows export of analysis data for documentation and notes that extremely large used ranges can prevent processing.

Official factual floor

  • Microsoft says Workbook Analysis may take seconds or minutes depending on workbook size and complexity.
  • Microsoft says the report can expose details such as formulas, data connections, linked workbooks, hidden sheets and errors.
  • Microsoft notes that a workbook cannot be processed when a sheet’s used range exceeds 100 million cells.
Scope: This guide cannot prove a workbook is accurate, detect every business-rule defect, evaluate macros or external systems completely, establish materiality, replace independent recalculation, approve personal-data handling, guarantee that add-in availability matches another user’s edition or turn a report export into an audit opinion.

Did You Know?

Workbook Analysis can reveal a connection to an external file even when the visible worksheet looks self-contained. A tidy screen can therefore depend on a source that another reviewer cannot access or verify.

Full chapter index

  1. 1. Define the workbook’s decision purpose
  2. 2. Preserve and identify the subject file
  3. 3. Confirm edition and add-in availability
  4. 4. Run and time Workbook Analysis
  5. 5. Read the Summary category
  6. 6. Read Workbook details
  7. 7. Read Formula details
  8. 8. Read Cell details
  9. 9. Read Range details
  10. 10. Interpret Warnings
  11. 11. Review external data and links
  12. 12. Export and protect analysis data
  13. 13. Corroborate and communicate findings
CHAPTER 1 OF 13

1. Define the workbook’s decision purpose

Back to contents

The mechanism

Risk depends on the decision, users, timing and tolerance for error.

Microsoft limits Spreadsheet Inquire to Excel for Windows in Microsoft 365 Apps for enterprise plans and equivalent editions. In this chapter, the decisive phrase is define the workbook’s decision purpose. 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 classroom budget and a payroll workbook receive the same generic risk label.

Workbook Analysis reports structure, counts, locations and rule-based warnings. It does not know the organisation’s correct formula, decide materiality, confirm source truth, prove an external connection is authorised or certify that a result is fit for a particular decision.

Decision sequence
  1. 1. name the decision
  2. 2. identify users
  3. 3. state material outputs
  4. 4. set review depth

Preserve the subject workbook read-only; identify the decision, owner and material outputs; confirm Excel for Windows and eligible enterprise edition; enable Inquire only under organisational policy; save if prompted; run Workbook Analysis; record time and version; review Summary, Workbook, Formulas, Cells, Ranges and Warnings; trace critical links, names, hidden sheets, errors and connections in context; export the analysis to a controlled location; corroborate material findings through formula review, recalculation, source comparison or Spreadsheet Compare as appropriate; document owner responses and unresolved limits; save, close and reopen the exact approved workbook; verify inputs, outputs, permissions and distribution copy. 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 subject-file identity, purpose, owner, Excel edition and platform, Inquire availability, save state, analysis timestamp, category counts, critical locations, sampled formula and connection evidence, warnings, corroboration, impact, owner response, remediation, exported-report identity, access controls, reviewer and unresolved limits.

Important boundary: A low-value total can still expose personal data.

Transfer: Purpose language supports proportionate 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.

CHAPTER 2 OF 13

2. Preserve and identify the subject file

Back to contents

The mechanism

Analysis should refer to one exact saved workbook.

Microsoft describes Workbook Analysis as a comprehensive view of logic structure and error status that can support assessment of potential risk and impact. In this chapter, the decisive phrase is preserve and identify the subject file. 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 report is exported after another person changes the source file.

Workbook Analysis reports structure, counts, locations and rule-based warnings. It does not know the organisation’s correct formula, decide materiality, confirm source truth, prove an external connection is authorised or certify that a result is fit for a particular decision.

Decision sequence
  1. 1. store read-only source
  2. 2. record filename and time
  3. 3. create working copy
  4. 4. control access

Preserve the subject workbook read-only; identify the decision, owner and material outputs; confirm Excel for Windows and eligible enterprise edition; enable Inquire only under organisational policy; save if prompted; run Workbook Analysis; record time and version; review Summary, Workbook, Formulas, Cells, Ranges and Warnings; trace critical links, names, hidden sheets, errors and connections in context; export the analysis to a controlled location; corroborate material findings through formula review, recalculation, source comparison or Spreadsheet Compare as appropriate; document owner responses and unresolved limits; save, close and reopen the exact approved workbook; verify inputs, outputs, permissions and distribution copy. 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 subject-file identity, purpose, owner, Excel edition and platform, Inquire availability, save state, analysis timestamp, category counts, critical locations, sampled formula and connection evidence, warnings, corroboration, impact, owner response, remediation, exported-report identity, access controls, reviewer and unresolved limits.

Important boundary: Cloud version history may not capture every dependency.

Transfer: Identity language supports auditability. 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.

CHAPTER 3 OF 13

3. Confirm edition and add-in availability

Back to contents

The mechanism

Inquire is not present in every Excel edition or platform.

Microsoft groups results into Summary, Workbook, Formulas, Cells, Ranges and Warnings, with selectable detail for locations and relationships. In this chapter, the decisive phrase is confirm edition and add-in availability. 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 Mac user is told the missing tab proves a configuration mistake.

Workbook Analysis reports structure, counts, locations and rule-based warnings. It does not know the organisation’s correct formula, decide materiality, confirm source truth, prove an external connection is authorised or certify that a result is fit for a particular decision.

Decision sequence
  1. 1. verify Windows Excel
  2. 2. check licence edition
  3. 3. ask about administrator policy
  4. 4. record unavailability honestly

Preserve the subject workbook read-only; identify the decision, owner and material outputs; confirm Excel for Windows and eligible enterprise edition; enable Inquire only under organisational policy; save if prompted; run Workbook Analysis; record time and version; review Summary, Workbook, Formulas, Cells, Ranges and Warnings; trace critical links, names, hidden sheets, errors and connections in context; export the analysis to a controlled location; corroborate material findings through formula review, recalculation, source comparison or Spreadsheet Compare as appropriate; document owner responses and unresolved limits; save, close and reopen the exact approved workbook; verify inputs, outputs, permissions and distribution copy. 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 subject-file identity, purpose, owner, Excel edition and platform, Inquire availability, save state, analysis timestamp, category counts, critical locations, sampled formula and connection evidence, warnings, corroboration, impact, owner response, remediation, exported-report identity, access controls, reviewer and unresolved limits.

Important boundary: Product entitlements and interfaces can change.

Transfer: Eligibility language supports accurate support. 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.

CHAPTER 4 OF 13

4. Run and time Workbook Analysis

Back to contents

The mechanism

Large or complex workbooks can take longer, and a save prompt may appear.

Microsoft allows export of analysis data for documentation and notes that extremely large used ranges can prevent processing. In this chapter, the decisive phrase is run and time workbook analysis. 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 long analysis is cancelled and the partial screen is treated as complete.

Workbook Analysis reports structure, counts, locations and rule-based warnings. It does not know the organisation’s correct formula, decide materiality, confirm source truth, prove an external connection is authorised or certify that a result is fit for a particular decision.

Decision sequence
  1. 1. save controlled copy
  2. 2. start the command
  3. 3. allow completion
  4. 4. record errors or timeouts

Preserve the subject workbook read-only; identify the decision, owner and material outputs; confirm Excel for Windows and eligible enterprise edition; enable Inquire only under organisational policy; save if prompted; run Workbook Analysis; record time and version; review Summary, Workbook, Formulas, Cells, Ranges and Warnings; trace critical links, names, hidden sheets, errors and connections in context; export the analysis to a controlled location; corroborate material findings through formula review, recalculation, source comparison or Spreadsheet Compare as appropriate; document owner responses and unresolved limits; save, close and reopen the exact approved workbook; verify inputs, outputs, permissions and distribution copy. 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 subject-file identity, purpose, owner, Excel edition and platform, Inquire availability, save state, analysis timestamp, category counts, critical locations, sampled formula and connection evidence, warnings, corroboration, impact, owner response, remediation, exported-report identity, access controls, reviewer and unresolved limits.

Important boundary: Extremely large used ranges can prevent processing.

Transfer: Process language supports reproducible 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.

CHAPTER 5 OF 13

5. Read the Summary category

Back to contents

The mechanism

Summary frames structure and content before detailed review.

Microsoft limits Spreadsheet Inquire to Excel for Windows in Microsoft 365 Apps for enterprise plans and equivalent editions. In this chapter, the decisive phrase is read the summary category. 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 formula count is reported without explaining whether the formulas drive a critical output.

Workbook Analysis reports structure, counts, locations and rule-based warnings. It does not know the organisation’s correct formula, decide materiality, confirm source truth, prove an external connection is authorised or certify that a result is fit for a particular decision.

Decision sequence
  1. 1. capture major counts
  2. 2. identify unusual features
  3. 3. link counts to purpose
  4. 4. choose drill-down priorities

Preserve the subject workbook read-only; identify the decision, owner and material outputs; confirm Excel for Windows and eligible enterprise edition; enable Inquire only under organisational policy; save if prompted; run Workbook Analysis; record time and version; review Summary, Workbook, Formulas, Cells, Ranges and Warnings; trace critical links, names, hidden sheets, errors and connections in context; export the analysis to a controlled location; corroborate material findings through formula review, recalculation, source comparison or Spreadsheet Compare as appropriate; document owner responses and unresolved limits; save, close and reopen the exact approved workbook; verify inputs, outputs, permissions and distribution copy. 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 subject-file identity, purpose, owner, Excel edition and platform, Inquire availability, save state, analysis timestamp, category counts, critical locations, sampled formula and connection evidence, warnings, corroboration, impact, owner response, remediation, exported-report identity, access controls, reviewer and unresolved limits.

Important boundary: Counts are indicators, not conclusions.

Transfer: Summary language supports triage. 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.

CHAPTER 6 OF 13

6. Read Workbook details

Back to contents

The mechanism

Workbook-level information can reveal sheets, links, connections and other structural features.

Microsoft describes Workbook Analysis as a comprehensive view of logic structure and error status that can support assessment of potential risk and impact. In this chapter, the decisive phrase is read workbook details. 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 hidden sheet is labelled suspicious without asking its documented purpose.

Workbook Analysis reports structure, counts, locations and rule-based warnings. It does not know the organisation’s correct formula, decide materiality, confirm source truth, prove an external connection is authorised or certify that a result is fit for a particular decision.

Decision sequence
  1. 1. list sheets and visibility
  2. 2. review links
  3. 3. inspect connections
  4. 4. name owners

Preserve the subject workbook read-only; identify the decision, owner and material outputs; confirm Excel for Windows and eligible enterprise edition; enable Inquire only under organisational policy; save if prompted; run Workbook Analysis; record time and version; review Summary, Workbook, Formulas, Cells, Ranges and Warnings; trace critical links, names, hidden sheets, errors and connections in context; export the analysis to a controlled location; corroborate material findings through formula review, recalculation, source comparison or Spreadsheet Compare as appropriate; document owner responses and unresolved limits; save, close and reopen the exact approved workbook; verify inputs, outputs, permissions and distribution copy. 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 subject-file identity, purpose, owner, Excel edition and platform, Inquire availability, save state, analysis timestamp, category counts, critical locations, sampled formula and connection evidence, warnings, corroboration, impact, owner response, remediation, exported-report identity, access controls, reviewer and unresolved limits.

Important boundary: Hidden does not mean malicious or erroneous.

Transfer: Structure language supports fair interpretation. 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.

CHAPTER 7 OF 13

7. Read Formula details

Back to contents

The mechanism

Formula categories point to logic patterns, errors and special forms that may deserve review.

Microsoft groups results into Summary, Workbook, Formulas, Cells, Ranges and Warnings, with selectable detail for locations and relationships. In this chapter, the decisive phrase is read formula details. 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: Every complex formula is called high risk while a simple wrong reference is missed.

Workbook Analysis reports structure, counts, locations and rule-based warnings. It does not know the organisation’s correct formula, decide materiality, confirm source truth, prove an external connection is authorised or certify that a result is fit for a particular decision.

Decision sequence
  1. 1. locate critical formulas
  2. 2. trace precedents
  3. 3. compare patterns
  4. 4. recalculate independently

Preserve the subject workbook read-only; identify the decision, owner and material outputs; confirm Excel for Windows and eligible enterprise edition; enable Inquire only under organisational policy; save if prompted; run Workbook Analysis; record time and version; review Summary, Workbook, Formulas, Cells, Ranges and Warnings; trace critical links, names, hidden sheets, errors and connections in context; export the analysis to a controlled location; corroborate material findings through formula review, recalculation, source comparison or Spreadsheet Compare as appropriate; document owner responses and unresolved limits; save, close and reopen the exact approved workbook; verify inputs, outputs, permissions and distribution copy. 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 subject-file identity, purpose, owner, Excel edition and platform, Inquire availability, save state, analysis timestamp, category counts, critical locations, sampled formula and connection evidence, warnings, corroboration, impact, owner response, remediation, exported-report identity, access controls, reviewer and unresolved limits.

Important boundary: Syntax complexity is not the same as business impact.

Transfer: Formula language supports analytical 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.

CHAPTER 8 OF 13

8. Read Cell details

Back to contents

The mechanism

Cell categories can expose constants, errors, blanks or formatting patterns relevant to control.

Microsoft allows export of analysis data for documentation and notes that extremely large used ranges can prevent processing. In this chapter, the decisive phrase is read cell details. 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 blank cell is treated as missing data when it is intentionally unused.

Workbook Analysis reports structure, counts, locations and rule-based warnings. It does not know the organisation’s correct formula, decide materiality, confirm source truth, prove an external connection is authorised or certify that a result is fit for a particular decision.

Decision sequence
  1. 1. inspect context
  2. 2. check input rules
  3. 3. compare neighbouring cells
  4. 4. ask the owner

Preserve the subject workbook read-only; identify the decision, owner and material outputs; confirm Excel for Windows and eligible enterprise edition; enable Inquire only under organisational policy; save if prompted; run Workbook Analysis; record time and version; review Summary, Workbook, Formulas, Cells, Ranges and Warnings; trace critical links, names, hidden sheets, errors and connections in context; export the analysis to a controlled location; corroborate material findings through formula review, recalculation, source comparison or Spreadsheet Compare as appropriate; document owner responses and unresolved limits; save, close and reopen the exact approved workbook; verify inputs, outputs, permissions and distribution copy. 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 subject-file identity, purpose, owner, Excel edition and platform, Inquire availability, save state, analysis timestamp, category counts, critical locations, sampled formula and connection evidence, warnings, corroboration, impact, owner response, remediation, exported-report identity, access controls, reviewer and unresolved limits.

Important boundary: Cell meaning depends on the model design.

Transfer: Cell language supports careful 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.

CHAPTER 9 OF 13

9. Read Range details

Back to contents

The mechanism

Named and used ranges can shape calculations, printing, validation and navigation.

Microsoft limits Spreadsheet Inquire to Excel for Windows in Microsoft 365 Apps for enterprise plans and equivalent editions. In this chapter, the decisive phrase is read range details. 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 large used range is assumed to contain meaningful data in every cell.

Workbook Analysis reports structure, counts, locations and rule-based warnings. It does not know the organisation’s correct formula, decide materiality, confirm source truth, prove an external connection is authorised or certify that a result is fit for a particular decision.

Decision sequence
  1. 1. inspect named ranges
  2. 2. check used range
  3. 3. review validation
  4. 4. identify stale scope

Preserve the subject workbook read-only; identify the decision, owner and material outputs; confirm Excel for Windows and eligible enterprise edition; enable Inquire only under organisational policy; save if prompted; run Workbook Analysis; record time and version; review Summary, Workbook, Formulas, Cells, Ranges and Warnings; trace critical links, names, hidden sheets, errors and connections in context; export the analysis to a controlled location; corroborate material findings through formula review, recalculation, source comparison or Spreadsheet Compare as appropriate; document owner responses and unresolved limits; save, close and reopen the exact approved workbook; verify inputs, outputs, permissions and distribution copy. 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 subject-file identity, purpose, owner, Excel edition and platform, Inquire availability, save state, analysis timestamp, category counts, critical locations, sampled formula and connection evidence, warnings, corroboration, impact, owner response, remediation, exported-report identity, access controls, reviewer and unresolved limits.

Important boundary: Used-range metadata may include historic formatting.

Transfer: Range language supports model maintenance. 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.

CHAPTER 10 OF 13

10. Interpret Warnings

Back to contents

The mechanism

Warnings flag conditions for investigation rather than automatic defects.

Microsoft describes Workbook Analysis as a comprehensive view of logic structure and error status that can support assessment of potential risk and impact. In this chapter, the decisive phrase is interpret warnings. 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 warning list is copied into a report as confirmed errors.

Workbook Analysis reports structure, counts, locations and rule-based warnings. It does not know the organisation’s correct formula, decide materiality, confirm source truth, prove an external connection is authorised or certify that a result is fit for a particular decision.

Decision sequence
  1. 1. read rule meaning
  2. 2. open affected location
  3. 3. test business consequence
  4. 4. record disposition

Preserve the subject workbook read-only; identify the decision, owner and material outputs; confirm Excel for Windows and eligible enterprise edition; enable Inquire only under organisational policy; save if prompted; run Workbook Analysis; record time and version; review Summary, Workbook, Formulas, Cells, Ranges and Warnings; trace critical links, names, hidden sheets, errors and connections in context; export the analysis to a controlled location; corroborate material findings through formula review, recalculation, source comparison or Spreadsheet Compare as appropriate; document owner responses and unresolved limits; save, close and reopen the exact approved workbook; verify inputs, outputs, permissions and distribution copy. 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 subject-file identity, purpose, owner, Excel edition and platform, Inquire availability, save state, analysis timestamp, category counts, critical locations, sampled formula and connection evidence, warnings, corroboration, impact, owner response, remediation, exported-report identity, access controls, reviewer and unresolved limits.

Important boundary: Rules cannot know every legitimate exception.

Transfer: Warning language supports defensible 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.

CHAPTER 12 OF 13

12. Export and protect analysis data

Back to contents

The mechanism

The exported report can contain formulas, locations and structural information about the subject file.

Microsoft allows export of analysis data for documentation and notes that extremely large used ranges can prevent processing. In this chapter, the decisive phrase is export and protect analysis data. 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 analysis workbook is emailed widely because it is called only a report.

Workbook Analysis reports structure, counts, locations and rule-based warnings. It does not know the organisation’s correct formula, decide materiality, confirm source truth, prove an external connection is authorised or certify that a result is fit for a particular decision.

Decision sequence
  1. 1. use a controlled folder
  2. 2. name source identity
  3. 3. limit recipients
  4. 4. retain under policy

Preserve the subject workbook read-only; identify the decision, owner and material outputs; confirm Excel for Windows and eligible enterprise edition; enable Inquire only under organisational policy; save if prompted; run Workbook Analysis; record time and version; review Summary, Workbook, Formulas, Cells, Ranges and Warnings; trace critical links, names, hidden sheets, errors and connections in context; export the analysis to a controlled location; corroborate material findings through formula review, recalculation, source comparison or Spreadsheet Compare as appropriate; document owner responses and unresolved limits; save, close and reopen the exact approved workbook; verify inputs, outputs, permissions and distribution copy. 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 subject-file identity, purpose, owner, Excel edition and platform, Inquire availability, save state, analysis timestamp, category counts, critical locations, sampled formula and connection evidence, warnings, corroboration, impact, owner response, remediation, exported-report identity, access controls, reviewer and unresolved limits.

Important boundary: Exported evidence can become stale immediately after source changes.

Transfer: Record language supports safe documentation. 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.

CHAPTER 13 OF 13

13. Corroborate and communicate findings

Back to contents

The mechanism

Material conclusions need contextual testing and an accountable owner response.

Microsoft limits Spreadsheet Inquire to Excel for Windows in Microsoft 365 Apps for enterprise plans and equivalent editions. In this chapter, the decisive phrase is corroborate and communicate findings. 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 dashboard is halted solely because the analysis shows many formulas.

Workbook Analysis reports structure, counts, locations and rule-based warnings. It does not know the organisation’s correct formula, decide materiality, confirm source truth, prove an external connection is authorised or certify that a result is fit for a particular decision.

Decision sequence
  1. 1. prioritise material outputs
  2. 2. test independently
  3. 3. seek owner explanation
  4. 4. state residual risk

Preserve the subject workbook read-only; identify the decision, owner and material outputs; confirm Excel for Windows and eligible enterprise edition; enable Inquire only under organisational policy; save if prompted; run Workbook Analysis; record time and version; review Summary, Workbook, Formulas, Cells, Ranges and Warnings; trace critical links, names, hidden sheets, errors and connections in context; export the analysis to a controlled location; corroborate material findings through formula review, recalculation, source comparison or Spreadsheet Compare as appropriate; document owner responses and unresolved limits; save, close and reopen the exact approved workbook; verify inputs, outputs, permissions and distribution copy. 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 subject-file identity, purpose, owner, Excel edition and platform, Inquire availability, save state, analysis timestamp, category counts, critical locations, sampled formula and connection evidence, warnings, corroboration, impact, owner response, remediation, exported-report identity, access controls, reviewer and unresolved limits.

Important boundary: No practical review can eliminate all spreadsheet risk.

Transfer: Conclusion language 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’s decision purpose

Risk depends on the decision, users, timing and tolerance for error.

Boundary: A low-value total can still expose personal data.

Preserve and identify the subject file

Analysis should refer to one exact saved workbook.

Boundary: Cloud version history may not capture every dependency.

Confirm edition and add-in availability

Inquire is not present in every Excel edition or platform.

Boundary: Product entitlements and interfaces can change.

Run and time Workbook Analysis

Large or complex workbooks can take longer, and a save prompt may appear.

Boundary: Extremely large used ranges can prevent processing.

Practice with realistic decisions

Read the Summary category

A formula count is reported without explaining whether the formulas drive a critical output.

  • capture major counts
  • identify unusual features
  • link counts to purpose
  • choose drill-down priorities

Read Workbook details

A hidden sheet is labelled suspicious without asking its documented purpose.

  • list sheets and visibility
  • review links
  • inspect connections
  • name owners

Read Formula details

Every complex formula is called high risk while a simple wrong reference is missed.

  • locate critical formulas
  • trace precedents
  • compare patterns
  • recalculate independently

Advice for students, families and educators

For students

  • Explain what a category reveals before calling it a risk.
  • Use a small test workbook to learn Inquire without exposing real data.

For families

  • Support safe file copies and privacy, not access to another person’s confidential spreadsheet.
  • Ask what decision the workbook supports and what was independently checked.

For educators

  • Distinguish inventory, warning, tested finding and conclusion in assessment rubrics.
  • Provide a non-Inquire route when learners lack the eligible Windows enterprise edition.

Frequently asked questions

Where is Workbook Analysis?

In eligible Excel for Windows editions, enable Inquire and choose Inquire > Workbook Analysis.

Is Inquire in every Excel edition?

No; Microsoft limits it to specified enterprise plans and equivalent editions.

What categories appear?

Summary, Workbook, Formulas, Cells, Ranges and Warnings.

Does it find hidden sheets?

It can report workbook structure including hidden sheets.

Can it report connections?

Yes, it can show data connections and linked-workbook information.

Are warnings confirmed errors?

No; investigate them in context.

Can I export the report?

Yes, Microsoft documents an Excel Export option.

Does export prove the workbook is correct?

No; corroborate material logic and sources.

What if analysis fails?

Record edition, add-in, workbook size and the exact error; use another authorised review route.

Why English?

Because summary, formula, cell, range, warning, connection, impact and finding describe different evidence stages.

Useful next reading

Closing thought

A useful workbook-risk note connects structure to consequence. Read the category, inspect the location, test the important logic and state what the evidence can and cannot prove.