Hi all,

This is a very general email, and I don't think this is possible but I thought I'd ask!

I've inherited an over-complex Excel-based reporting structure with insane amounts of VLOOKUPS running throughout many, many files.

What I am trying to do is create a map of how all these files interlink i.e. File A may be "VLOOKUPed" by Files C, D, and M. However, I do not know this for definite. I can use the "Trace Dependents" on individual cells, but this is not possible as I'd need to check every cell! My ultimate aim is to cut out the inter-file VLOOKUPS.

So my question is: Is there a way that I can open File A, and automatically look at ALL files that look at or feed from File A?

Many Thanks,
Nick