Inconsistent formulas
Rows in a block that do not follow the same formula pattern are listed.
Workbook audit
Upload a workbook and review points that often hide errors: inconsistent formulas, a formula replaced by a value, external links, hidden sheets, and suspicious pattern changes. This helps identify review points. It is not perfect Excel forensic analysis.
A total can look right while one row is a hardcoded override. Hidden sheets and external links make a file harder to review. AuditExport inspects structure and formula patterns; it does not execute Excel like a desktop client.
How it works
Step 1
Bring the .xlsx you would otherwise open and click through.
Step 2
The workbook engine inspects sheets, formulas, and structural signals.
Step 3
Inconsistent formulas, overrides, links, hidden sheets, and broken references where supported.
Step 4
Use findings as review points, not as a claim that every Excel issue was found.
Step 5
Pair with spreadsheet comparison when you have an older file.
What this workflow is designed to do with uploaded files.
Rows in a block that do not follow the same formula pattern are listed.
A constant sitting where neighbors still have formulas is a review point.
Links to other workbooks are surfaced when present in the file.
Sheets that are hidden still exist in the file and can be listed.
A formula that changes mid-column is easier to see as a finding than by eye.
Where the file records calculation settings that affect review, those can appear.
Unsupported or broken references are reported where the engine can detect them.
A close workbook has 11 months of a SUM formula and one month typed as 184,200. The audit lists that cell as formula-replaced-by-value. A hidden 'Calc' sheet and an external link to Rates.xlsx are also listed. Those are review points, not a guarantee the file is error-free.
Sample preview
Fictional sheet names. Demonstration only.
| Reference | Counterparty | Amount | Status | Note |
|---|---|---|---|---|
| P&L!D18 | December total | 184,200 | Formula → value | Neighbors still use SUM |
| Calc | Hidden sheet | — | Hidden sheet | Present in the file |
| Rates.xlsx | External link | — | External link | Linked workbook |
| Cash!F12 | Broken ref | — | Broken reference | Where supported |
Workbook audit reduces the chance that a hardcoded override or hidden sheet is missed. It does not promise complete Excel forensics or that every spreadsheet risk will be found.
Continue with the workflows that usually sit next to this one.
The audit inspects workbook structure and formula text. It is not a full Excel calculation engine.
No. It helps identify review points. It does not promise perfect forensic analysis.
Yes. Use spreadsheet comparison for old versus new, and reporting to share findings.
Upload the file. Review formula overrides, hidden structure, and links.