Pages in this article
-
Why RefTreeAnalyser?
-
Screenshots of RefTreeAnalyser
-
Version information
-
Operating instructions
Download
The most recent version is
is available for
download here, click the link that says "Download
RefTreeAnalyser (Free demo!!!)".
Screenshots
Below is a screenshot of RefTreeAnalyser, showing both dependents and
precedents of a cell.
![Screenshot of RefTreeAnalyser, the ultimate Excel formula auditing tool.](images/RefTreeAnalyser.gif)
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.
If there are any objects using the current cell, those will be shown
in black. Validation formula references and conditional formatting
formula references are shown in black as well.
The Visualize option shows improved trace precedents arrows:
![Visualize option of RefTreeAnalyser](images/RefTreeAnaylserVisualize.gif)
![Buy RefTreeAnalyser now!](images/fspaynowbutton.png)
The Object Reference Enables you to see what your cells are used by
objects on your sheets, such as Pivot tables, Charts and etcetera.
![RefTreeAnalyser Object References Screen](images/RefTreeAnalyserObjects.gif)
And here is a screenshot of the tool after detecting circular
references:
![RefTreeAnalyser showing circular references](images/RefTreeAnalyserCirc.gif)
RefTreeAnalyser integrates nicely with Excel. You have the choice of
either a separate tab on the ribbon called RefTreeAnalyser:
![RefTreeAnalyser ribbon interface](images/RefTreeAnalyser2007UIOwnTab.gif)
Or a separate section on the formulas tab:
![RefTreeAnalyser ribbon interface](images/RefTreeAnalyser2007UI.gif)
![Buy RefTreeAnalyser now!](images/fspaynowbutton.png)