xlsx_external_links
List external workbook references in an .xlsx file, identify absolute paths and network shares that break when the file moves. Audit formula dependencies before sharing workbooks.
Instructions
list every external workbook reference this file depends on — =[Budget.xlsx]Sheet1!A1 style formulas. Per link: target path (decoded), classification (http / network share / absolute / relative), sheets pulled from the external workbook, count of cached cell values, and defined-name references.
No other tool can do this consistently: pandas, openpyxl, and ExcelJS all surface external links partially or inconsistently. xlsx_external_links reads xl/externalLinks/*.xml directly and warns when targets are absolute paths or network shares — those break the moment the workbook moves elsewhere.
USE WHEN: about to send a workbook somewhere and want to know if its formulas will break (broken external refs are a top-3 silent corruption mode in finance workflows). Or auditing for accidentally-leaked file paths to internal network shares. Or doing dependency analysis on a model. Free tier — counts against the 10k/mo cap.
DO NOT USE WHEN: just reading values (use xlsx_read).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file_b64 | Yes |