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.

Trainings

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

Third party tools

Speed up your file

FastExcel
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
Deze pagina in het Nederlands

RefTreeAnalyser: The ultimate Excel Formula Auditing tool

For Microsoft Excel

Excel formula auditing taken to the next level!

Features:

Ordering

A single user license for RefTreeAnalyser costs € 30 (excluding local VAT)

Buy RefTreeAnalyser now!

Prices

Number of licenses Price per licence
1-10 € 30.00
11-50 € 23.00

Contact me if you'd like to order more than 50 licenses

Free Download

Use the links below to download the tool.

The tool will work without a license code but with (only slightly) limited functionality. After purchasing a license, you can simply enter the license code into the tool's settings dialog. The limitations will be removed instantly.

Current Excel versions (Excel 2007 and up)

Download RefTreeAnalyser for Excel 2007 to 2016 (Free demo!!!) V2.0 (Build 116, Updated Aug 23, 2017, downloaded: 9,821 times)

Excel 2003

Please note that the 2003 version will no longer be updated!

Download RefTreeAnalyser for Excel 2003 (Free demo!!!) V2.0 (Build 082, Updated Dec 15, 2015, downloaded: 998 times)

Blocked files problem

Recently (I write this in August 2016), Microsoft has "enhanced" security and is now blocking any files that are downloaded from the internet. This means that any add-in you try to open after downloading will simply not open in Excel (without display of a warning message!). To resolve this, follow these steps:

1. Copy the add-in from the zip file to any folder

2. Right-click the xla(m) file and choose properties:

Select file properties

3. Click the Unblock button:

Click Unblock

Money back guarantee

If you are in any way dissatisfied with RefTreeAnalyser, contact me within 30 days after your purchase and I'll issue a refund.

Buy RefTreeAnalyser now!

What is RefTreeAnalyser?

Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be!

Now there is the RefTreeAnalyser, the must-have expansion of your Formula tab of the Ribbon!

Screenshot of RefTreeAnalyser Visualize option of RefTreeAnalyser

With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze. RefTreeAnalyser makes tracing precedents and dependents a lot easier than Excel's built-in tools. Read more about RefTreeAnalyser.

Supported Excel versions

RefTreeAnalyser is designed to work with Excel 2000 and up, including all 64 bit Excel versions.

More information

Buy RefTreeAnalyser now!

 


Comments

Showing last 8 comments of 152 in total (Show All Comments):

 


Comment by: Raffaele (3/30/2017 6:37:34 PM)

Hi, many compliments for the addin I'd find it very useful in the Precedents feature, to see the value of the precedents not as ".value" but as ".text". So for example, if a precedent has a value of 1253514,254, but is shown (through formatting) as 12,5 (millions), it would be much better to see it in the precedents window as 12,5 than 253514,254 (as it is today). Thanks!

 


Comment by: Jan Karel Pieterse (3/31/2017 8:19:10 PM)

Hi Raffaele,

Nice suggestion, thanks.

 


Comment by: John Hackwood (7/23/2017 6:08:22 AM)

Hey Jan Karel

I bought your RefTreeAnalyser and its a great tool and I use it when I have a doozy of a formula.

Lately I have been getting the msg upon opening Excel when it loads Add-ins that checking for updates as failed. I guess I could unclick the check for updates automatically but has the support for this add-in now stopped and that's the reason?

I could send you a screen shot if you want.

cheers
John

 


Comment by: Jan Karel Pieterse (7/23/2017 10:44:33 AM)

Hi John,

RefTreeAnalyser is still fully supported indeed and I'm working (slowly) on version 3.

So I guess the problem is on your end. Perhaps a setting in your firewall?

 


Comment by: John (7/23/2017 1:32:15 PM)

Hi again Jan Karel, OK will try that.

Sorry I didn't know this comment was going to be public and gave my license no. in the above comment, so please delete/redact it. thanks John

 


Comment by: Jan Karel Pieterse (7/23/2017 8:21:31 PM)

Hi John,

Done!

 


Comment by: Den (8/6/2017 12:14:54 AM)

Hi Jan,
there is an error in tracing when i use named table with name in cyrillic characters. If I use the named column with сyrillic, there is no error.

Some suggestions for next release:
1)In the interface, select the structure of the formula (not just each individual element) and display the calculated value for each block. If the formula uses a logical expression to calculate the result, display how the elements of the compared block match the condition (select suitable ones). If you use the array formula in the condition, display the matching array elements.
2) If the formula uses ranges / arrays of the same dimensions, display the array elements under each other. That is, it is necessary to align to the widest value of the element of the array / range group.
3) Make it possible to correct the formula via the add-in interface.
4) Connect the add-in to all Excel windows in which you entering the formulas:
a) Conditional formatting formula;
b) Data validation formula;
c) Formula for the named range in Name manager.
To check the operation of the formulas in these blocks, it is necessary to select the cell with which to calculate the formula. It is especially important when the formula uses an offset.

Thanks for the excellent add-on and further success!

 


Comment by: Jan Karel Pieterse (8/13/2017 5:14:35 PM)

Hi Den,

Thanks for leting me know!

 


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.

Please enter your name (required):

Your e-mail address (optional but if you want me to respond it helps!; will not be shown, nor be used to send you unsolicited information):

Your request or comment:

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

Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.