RefTreeAnalyser Screenshots
Below is a screenshot of the RefTreeAnalyser, showing both dependents and precedents of a cell.

Note that it shows the value in each cell next to its address and also highlights references which evaluate to an error in red automatically.
And here is a screenshot of the tool after detecting circular references:

RefTreeAnalyser integrates nicely with Excel 2007 and 2010:







Comments
Have a question, comment or suggestion? Then please use this form.
If your question is not directly related to this web page, but rather a more general "How do I do this" Excel question, then I advise you to ask your question here: www.eileenslounge.com.