How to track usage of named ranges and find the last reference in a huge workbook?

I've inherited a massive Excel file with dozens of sheets and a ton of named ranges. My problem is figuring out where these ranges are actually used. Some of them seem to be stubs leftover from old versions, and I want to clean them up without breaking anything.

Is there an efficient way to trace all cell references that depend on a specific named range?
I've tried using Trace Dependents but it gets messy with so many links. Looking for any tips on auditing named range usage across a whole workbook.