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:







Comments
Have a question, comment or suggestion? Then please use this form.