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!

What has changed?

PerfectXL Compare, for Spreadsheet Comparison
This Excel compare tool is fast, reliable, and easy to use. Compare two Excel files now and see for yourself!
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!



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

A license includes:

Buy RefTreeAnalyser now!


  Price per license
  € 30.00
  € 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 152, Updated May 21, 2020, downloaded: 16.309 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: 2.676 times)

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!



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


Comment by: David (9-10-2019 03:25:00)

Can one license key be assigned to multiple licenses?

If we purchase additional licenses, can the same license key be used for those new licenses?

Can we allocate/deallocate users to licenses from your web site?


Comment by: Jan Karel Pieterse (9-10-2019 10:50:00)

Hi David,

Yes, you can use a single key for multiple licenses. There is no means to deallocate registrations, but as long as the number of registrations using the license key stays within reason there is no need to do so.

I do prefer that you use the new license code if you purchase additional licenses.


Comment by: john (4-1-2020 10:42:00)

The addin is perfect but can you add evaluate formula option(like in excel) in this addin


Comment by: Jan Karel Pieterse (6-1-2020 11:49:00)

Hi John,

Thank you for the suggestion!


Comment by: Alejandro (14-7-2020 22:14:00)

Hi, this license this sale in chile?, exist one representative in chile for companies?


Comment by: Jan Karel Pieterse (18-7-2020 19:10:00)

Hi Alejandro,

You can buy the license directly from this website.


Comment by: Gearoid (1-10-2020 16:01:00)

Hi there,

Does this work with Excel 365. Can I trial it before I buy it?



Comment by: Jan Karel Pieterse (2-10-2020 16:28:00)

Hi Gearoid,

Yes indeed it works with any Excel version (for Windows!) as of Excel 2007 up to and including Excel 365.
You can download the tool and try it as it automatically works in demo mode with limited functionality.

Once you're happy with the tool you can go back to this page, purchase a license (sent to you by email).

You can enter the license code into the settings dialog of the tool and it will unlock into the full version automatically.


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.

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