RefTreeAnalyser Screenshots

Pages in this article

1. Why RefTreeAnalyser?
2. Screenshots of RefTreeAnalyser
3. Version information
4. Quick Operating instructions
5. Full help

Download

You can use this button to download the add-in. Try it for free!

Download RefTreeAnalyser

Screenshots

Below is a screenshot of 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. Note how Objects that either refer to the current cell (Dependent objects) and objects the current cell uses (precedents from object formulas in Validation and Conditional Formatting) are listed (when the Objects box is checked).

The Visualize option shows improved trace precedents arrows:

Buy now (Paypal and credit cards supported)

The Object Reference Enables you to see what your cells are used by objects on your sheets, such as Pivot tables, Charts and etcetera.

And here is a screenshot of the tool after detecting circular references:

RefTreeAnalyser integrates nicely with Excel. You will find its options on a separate tab on the ribbon called RefTreeAnalyser:

Buy now (Paypal and credit cards supported)

Frequently asked Questions