xlsx_healer_diagnose
Diagnose broken external workbook references, missing defined names, #REF! errors, and credential-embedded Power Query connections in .xlsx files. Returns structured report for downstream repair.
Instructions
produce a structured diagnostic report of external references that are broken or at risk in a workbook. Returns five classes of finding: (1) external-workbook references that can't resolve, (2) defined-name external refs, (3) Power Query connections with embedded credentials, (4) #REF! propagation maps from upstream breakage, (5) multi-hop chains (workbook → workbook → workbook). Findings carry reference_id keys that downstream cure operations key on.
USE WHEN: a workbook shows #REF! errors, an agent moves a file and refs need rewriting, a customer reports "the workbook stopped working after we reorganized SharePoint", or auditing a corpus for hidden external-link breakage before sharing.
DO NOT USE WHEN: the user wants the cleaning/normalization surface (use xlsx_data_clean — different concern). Or when there is no .xlsx source path (Healer reads the source bytes, doesn't reconstruct from a structured spec).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file_b64 | Yes |