Why RefTreeAnalyser?

Easily navigate the reference tree

The formula auditing capabilities of Excel are limited in that they display a bunch of arrows from the current cell to it's dependents and/or precedents. Navigating these arrows is relatively hard to do, especially if there are more than just one off-sheet reference and the combination of workbookname and sheetname is long (you're unable to see the cell addresses):

The RefTreeAnalyser greatly eases the navigation of dependents and precedents. You simply click on a found reference in a simple tree-like structured view and the accompanying cell or range of cells is selected.

Quickly see what cells are referred to

Although Excel does enable you to see what cells precede your cell and/or what cells use the current cell, getting an overview of them is quite hard. See the example below...

The RefTreeAnalyser greatly simplifies this as well: you get one tree-like overview of all cells that depend on the active cell and all cells that precede the current cell (and both may go up to 5 levels deep down/up the dependency tree!). The screenshot below shows what the same analysis looks like with RefTreeAnalyser:

Locate all circular references

Excel does detect if a workbook contains circular references, but only enables you to navigate one.

The RefTreeAnalyser detects all your circular references and shows them to you in one -easy to navigate- treeview.

Generate a report quickly

Excel's formula auditing tools do not have any reporting options.

The RefTreeAnalyser comes with a Report option which writes the current analysis to a new worksheet in your workbook. The report may look like this:

Comments

All comments about this page:

Comment by: James (3/26/2009 7:37:09 AM)

How does your tool handle named ranges. Does it display the named range or the underlying cell reference? cheers -j

Comment by: Jan Karel Pieterse (3/26/2009 8:55:24 AM)

Hi James,

It shows the named range at level 1, for level 2 refs it shows addresses.

Comment by: Bill (7/2/2009 9:56:51 AM)

Does it allow you to jump between different tabs to trace a precedent or dependent?

Comment by: Jan Karel Pieterse (7/2/2009 12:18:31 PM)

Hi Bill,

Yes it does. And if there are external links and the source file(s) are open those will be shown and travelled too.

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.