This is the kind of post that resonates with anyone who has ever inherited a spreadsheet. You open a workbook, see dozens of sheets and a long list of named ranges, and immediately feel the weight of someone else's decisions. The original author did not leave a map. You are left to guess which ranges are essential and which are just digital clutter. The frustration is real, and the question is a good one: how do you trace usage across a whole workbook without descending into chaos?
Our take is straightforward: the tools you have been using were designed for a different era. Trace Dependents works fine when you are auditing a single formula, but it breaks down when you are trying to understand an entire system. Named ranges are powerful because they let you write formulas that read like English, but that power becomes a liability when you have no way to see where each name is referenced. The fact that this user had to ask the question at all tells us something important. Spreadsheet software has not kept up with the complexity of the work people actually do. You should not need a third-party add-in or a VBA script just to find out whether a named range is still in use.
What this means in practical terms is that you need a different approach. Start by exporting the full list of named ranges from the Name Manager. Then, use a simple search across the entire workbook for each name. The trick is to search for the name as it appears in formulas, usually without the sheet reference, and to look in all sheets at once. Excel's Find function can do this if you set the scope to Workbook. It is manual, but it works. For a cleaner solution, consider using a formula audit tool that can generate a dependency map. Some modern spreadsheet platforms already include this feature natively. The point is that cleanup is possible, but only if you treat the workbook as a system to be understood, not just a file to be edited.
The real lesson here is about ownership. When you inherit a workbook, you inherit its problems. Cleaning up named ranges is not just about reducing clutter. It is about regaining control. Every unused range you remove is a variable you no longer have to worry about. Every dependency you trace is a risk you have eliminated. The goal is not to make the spreadsheet perfect overnight. It is to make it manageable enough that you can trust it again. Start with the names you suspect are stubs. Confirm they are unused. Delete them. Then move on to the next. You will be surprised how much clarity comes from simply knowing what is alive and what is dead.