Audit workbook
audit_workbookCheck a workbook for broken/circular references, hardcoded plugs, external links, volatile functions, hidden sheets, stale caches, and Excel-vs-computed mismatches; recalculates, returns JSON report.
Instructions
Check a session's whole workbook for modeling problems and return a JSON report: broken references, circular references and whether they converge, hardcoded plugs (a constant or odd formula breaking a run of consistent formulas), external links, volatile functions, hidden sheets and names, stale cached values, and a verification block comparing Basis's computed values with the ones Excel last saved. Recalculates first and changes nothing else. Use it as a health check before trusting or handing off a model; for structure only use inspect_model, for one value's lineage trace_dependencies, and to compare two files diff_workbooks.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| session_id | Yes | Session ID returned by create_session (list_sessions shows the open ones) |