R021 — Hidden Sheet Dependency
Executive Summary
Key Takeaways
- ✓ R021 flags a hidden or very-hidden worksheet that at least one visible-sheet formula references — an invisible dependency a standard review would not surface.
- ✓ A dormant hidden sheet with no inbound references from a visible sheet is not flagged, since it carries no live dependency risk regardless of what it contains.
- ✓ References from one hidden sheet to another hidden sheet are also not flagged — the risk R021 addresses is specifically a visible calculation silently depending on hidden content.
- ✓ One finding is produced per hidden sheet with at least one live visible-sheet reference, listing every referencing cell as evidence.
Purpose¶
R021 detects a hidden or very-hidden worksheet that is referenced by at least one formula on a visible worksheet — an invisible dependency that standard navigation of the workbook would not surface.
Detection Logic¶
Every worksheet's visibility state (visible, hidden, or very-hidden) is checked. For each hidden or very-hidden sheet, every formula on a visible sheet is scanned for a reference to it. A hidden sheet with at least one such inbound reference from a visible sheet is flagged, with every referencing visible-sheet cell listed as evidence. A hidden sheet with no inbound references from any visible sheet is not flagged — it may be dormant, and carries no live dependency risk regardless of its own contents. References from one hidden sheet to another are also not flagged, since the specific risk this rule addresses is a visible calculation depending on hidden content, not hidden content depending on other hidden content.
Why It Matters¶
A hidden worksheet does not appear in Excel's standard worksheet tab navigation, and a very-hidden worksheet cannot even be unhidden through the ordinary user interface. A reviewer examining a model through normal navigation will never see a hidden sheet's contents unless they specifically know to look for it and unhide it. If a visible calculation — a valuation output, a summary figure — silently depends on a value computed on a hidden sheet, any error, stale data, or unreviewed edit on that hidden sheet propagates directly into the visible output with no indication in the visible parts of the model that the dependency even exists.
Evidence Produced¶
A triggered R021 finding's evidence lists every visible-sheet cell (up to a display limit) whose formula references the hidden sheet, together with a description naming the hidden sheet and noting that its contents are not visible during standard review.
Severity¶
High. Weight 7.0. R021 is not one of the five critical-override rules. Confidence is always high, since sheet visibility and formula references are both directly observable, deterministic facts.
Example¶
Trigger. A "Working Calcs" worksheet is set to hidden, and a visible "Summary" worksheet's formula
reads ='Working Calcs'!$B$20. R021 flags the hidden "Working Calcs" sheet, listing the Summary sheet's
referencing cell as evidence.
Non-trigger. The same "Working Calcs" worksheet is hidden, but no formula on any visible sheet references it — perhaps it was an earlier draft retained for reference but no longer live. R021 does not fire, since there is no visible-sheet dependency on the hidden sheet's contents.
Recommended Remediation¶
Either unhide the worksheet so its contents are visible during standard review, or, if the hidden sheet's content genuinely needs to remain hidden, replace the visible sheet's dependency on it with a value that does not require navigating to hidden content to verify.
Related Rules¶
R021 shares the Integrity Controls taxonomy category with R020 — Anchor Drift — see the Rule Taxonomy page for the full classification.
Related Articles¶
- Hidden Worksheets — the Knowledge Centre's buyer-facing technical guide to hidden worksheet structural risks.
Version History¶
No version-specific changes to R021's severity, weight, or category are recorded as of engine version 2.1.0. This section will be updated in the same edit as any future change to the rule's declared attributes.
How OXXON tests thisRun a free structural check with FMAE
Frequently Asked Questions
What does FMAE rule R021 check for?
Formulas on a visible worksheet that reference a hidden or very-hidden worksheet — creating a dependency a reader navigating the workbook normally would never see, since hidden sheets do not appear in the standard worksheet tab view.
Does R021 flag every hidden worksheet in a model?
No. A hidden worksheet with no formulas on any visible sheet referencing it is not flagged — it may simply be dormant or retained for reference, carrying no live dependency risk. Only hidden sheets with at least one inbound reference from a visible sheet are flagged.
Does a reference from one hidden sheet to another hidden sheet get flagged?
No. R021 specifically addresses the case where a visible calculation depends on hidden content a reviewer would not see. A hidden-to-hidden reference does not create that specific visibility gap, since the referencing formula is itself already hidden from standard review.
Related Articles
FMAE Rule Taxonomy
Every rule in the FMAE structural rule pack declares a category attribute at the point it is defined in source — this is not a classification imposed on the rules afterward for documentation purposes, it is the classification the engine itself uses. Six categories cover all 26 rules — Structural (18 rules), Assumptions Governance (1), Integrity Controls (2), Structural Hygiene (1), Aggregation Logic (1), and Model Governance (3). This page publishes that taxonomy as the FMAE equivalent of a control catalog's classification scheme, cross-linked to the Rule Reference page for each member rule.
Finding Data Model & Confidence
Every FMAE finding carries the same fixed structure — which rule triggered it and that rule's identity at the time it ran, its evidence, a narrative explanation, and a confidence label of high, medium, or low. Confidence is a deterministic categorical label derived from how strongly a row's cells agree on a pattern, not a machine-learning probability estimate. Stating this plainly matters, since describing FMAE's confidence as AI-derived or probabilistic would overstate what the engine actually does.
R020 — Anchor Drift
R020 (Reference Anchor Drift) checks, within a row of formulas that already share the same structural pattern, whether every reference to a given shared cell uses the same anchor class — relative, column-absolute, row-absolute, or fully absolute. When most of the row's formulas anchor a reference one way and a minority anchor the same logical reference a different way, the minority is flagged — the formula was very likely copy-pasted or edited incorrectly, a silent source of calculation error if the row is later extended or its cells copied further.
Hidden Worksheets in Financial Models
A hidden worksheet in an Excel financial model is a worksheet that does not appear in the worksheet tab bar during normal navigation but remains part of the workbook and participates in the model's calculation structure. Excel supports two levels of worksheet hiding: standard hiding (via the right-click context menu) and very hidden (via the VBA editor), which cannot be unhidden through the standard interface. Hidden worksheets are a structural risk in financial models because they contain calculations that affect the model's outputs but are not visible to users or reviewers examining the model through normal means.