The user who posted this question knows exactly what they're up against. A 30-sheet workbook with formulas that snake across tabs is not a spreadsheet. It's a liability. Excel's built-in Trace Precedents and Trace Dependents work well enough for a single cell, but they were never designed to map the logic of an entire model. When engineering teams keep layering on new sheets without documentation, the result is something that no one fully understands and everyone is afraid to touch. That frustration is not a user failure. It is a tool failure.
The tools that exist today, add-ins and manual workflows, can help, but they are band-aids on a broken process. Some can extract formulas and flag cross-sheet references. Others generate static dependency maps. But none of them transform the fundamental experience of opening a stranger's workbook and trying to decode its hidden logic. What this user really needs is a system that treats the workbook as a living document, one that can explain itself. Imagine a tool that not only visualizes the web of dependencies but also summarizes each sheet's role in plain language. That would turn hours of detective work into seconds of insight.
This is where AI-native thinking changes the equation. Traditional spreadsheets were built for a world where the user did all the thinking. The formulas were the logic, and the user had to trace every thread. But a modern approach can reverse-engineer that logic automatically. It can read the formulas, recognize patterns, and generate a readable map of how data flows from one sheet to another. It can even flag orphaned references or circular dependencies that would otherwise stay hidden until they break something. The technology to do this already exists, it just hasn't been applied to the spreadsheet problem at scale.
For anyone who has inherited a bloated Excel model, the message is simple: you are not asking for too much. You are asking for the right thing, and the industry has been too slow to deliver it. The solution is not to add more cell-level tracing tools. It is to build a layer of intelligence on top of the workbook that can explain itself. That is the future of data work, not more manual effort, but tools that do the hard work of understanding for you.