Most Valuable Professional

View Jan Karel Pieterse's profile on LinkedIn subscribe to rss feed
Subscribe in a reader

Subscribe to our mailing list

* indicates required

File crashes Excel!!

Save my workbook!
The best tool for salvaging problematic workbooks.


Excel VBA Masterclass (English)
Excel VBA for Financials (Dutch)

Third party tools

Speed up your file

The best tool to optimise your Excel model!

Repair your file

Stellar Phoenix Excel Repair
Best tool to repair corrupt Excel sheets and objects
Home > English site > Products > RefTreeAnalyser > Screenshots of RefTreeAnalyser
Deze pagina in het Nederlands

RefTreeAnalyser Screenshots

Below is a screenshot of the RefTreeAnalyser, showing both dependents and precedents of a cell.
Screenshot of RefTreeAnalyser, the ultimate Excel formula auditing tool.

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

Buy RefTreeAnalyser now!

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

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

RefTreeAnalyser integrates nicely with Excel:

Buy RefTreeAnalyser now!


All comments about this page:

Comment by: Anthony Lisbona (6-2-2014 06:17:22)

Does RefTreeAnalyser check if a conditional format or a volatile function is dependant on a specific cell (both of which Excel's 'Trace Dependants' cannot)?


Comment by: Jan Karel Pieterse (6-2-2014 19:31:22)

Hi Anthony,

Yes it does!
What kind of "Volatile" function do you mean? INDIRECT? It doesn't do those.


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:

Please enter your name (required):

Your e-mail address (optional, will only be used to inform you when your comment is published or to respond to your question directly):

Your request or comment (max 2000 characters):

To post VBA code in your comment, use [VB] tags, like this: [VB]Code goes here[/VB].

I give permission to process this data and display my name and my comment on this website accoring to our Privacy Policy.