back at the dawn of history, when computers were still steam powered, I was a
programmer ( then a designer, then an analyst, then an architect ). In those
long-ago days of yore, we used programming languages to do the stuff I'm now
doing with Excel. One of the tools we had to do that effectively was called
a "Variable Cross Reference" - a list of every place in the program where
each variable was used - it was INVALUABLE in debugging.

In Excel, the closest thing we have is Trace Precedents, and Trace
Dependants. Does anybody out there know of a "Cell Reference" tool ? It
would list all cell Precedents and Dependents at once. ( or anything like
this )

thanks for your help