How do you figure out the logic of a huge Excel workbook with dozens of linked sheets and circular references?

I sometimes receive Excel workbooks that have 20–30 worksheets with a lot of formulas referencing each other across sheets, and it can take a long time to understand how everything is connected. Excel has things like Trace Precedents / Trace Dependents, but that works mostly at the cell level and becomes difficult to follow when the workbook is large.

I’m wondering if there are any tools that can:

- Automatically extract formulas from a workbook

- Detect cross-sheet references -Generate some kind of visual dependency map between sheets

- Help explain what each sheet is doing Basically something that can help reverse-engineer a complex Excel model more quickly.

Are there any add-ins, tools, or workflows people here use for this?

It's very frustrating and becomes a nightmare when engineering companies keep adding on to bloated Excel files without documentation on how the model works. Tracing the formulas manually is such a pain