RefTreeAnalyser: The ultimate Excel Formula Auditing tool

For Microsoft® Excel®

Excel formula auditing taken to the next level!

Content

Features

  • Easy Auditing of formula dependents and precedents, including object dependencies (charts, pivot tables, form controls, Validation formulas, Conditional formatting formulas, etcetera)
  • Find circular references (yes, all of them!)
  • Trace errors
  • Find out which cells are used by all kinds of things in your file: pivot tables, charts, conditional formatting, data validation, forms and ActiveX controls and etcetera.
  • Generate a table of content containing not just your worksheets, but also your charts, pivot tables and (form) controls
  • Time your workbook calculation for each worksheet to find bottlenecks
  • Check columns for formula inconsistencies

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 (Free demo!!!) V3.1 (Build 187, Updated September 22, 2022, downloaded: 21.246 times)

After downloading the file, please read the readme.txt file, it contains important installation instructions. In addition, please read: Excel add-ins fail to load

Excel 2003

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

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

Ordering licenses

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

A license includes:

  • Installation and perpetual use of the tool on two computers
  • One year of free updates.

Buy RefTreeAnalyser now!

Prices

Amount
  Price per license
1-10
  € 30.00
11-50
  € 27.50
51-100
  € 25.00
101-300
  € 22.50
301+
  € 20.00

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

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!

Here is RefTreeAnalyser, your 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 2007 and up, including all 64 bit Excel versions.

More information

  1. Why RefTreeAnalyser?
  2. Screenshots of RefTreeAnalyser
  3. Version information
  4. Operating instructions

Buy RefTreeAnalyser now!

 

Comments

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

 

Comment by: Alejandro Santiago (29-6-2021 17:33:00) deeplink to this comment

I bought the license a few years ago.
It throws an error checking for updates.
Am I not able to keep using the addon unless I repurchase the license?

Comment by: Jan Karel Pieterse (30-6-2021 10:49:00) deeplink to this comment

Hi Alejandro,

No, the license is still valid. Just turn off automatic updates in Settings.

If you want to use your license on a new machine, make sure you copy the reftreeanalyserxl.xlam file from your old machine, as downloading a new version from my website will not work.

Comment by: Axel (16-2-2022 14:27:00) deeplink to this comment

Hi, can you confirm whether this is working with the latest version of excel? When I double click the refutility, it doesnt bring up any windows (just switches to the first open excel window).

Comment by: Jan Karel Pieterse (16-2-2022 14:55:00) deeplink to this comment

Hi Axel,

It should work, yes. It does for me (I use Microsoft 365 monthly channel).
Perhaps you are experiencing this issue: https://jkp-ads.com/Articles/Excel-Add-ins-fail-to-load.asp

Comment by: Kanwaljit Singh Dhunna (3-7-2022 20:04:00) deeplink to this comment

Hello Sir,
Greetings of the Day !
Does the Reftreeanalyser works with LAMBDA and Dynamic Array Formulas or not ?

Kanwaljit

Comment by: Jan Karel Pieterse (3-7-2022 22:24:00) deeplink to this comment

Hi Kanwaljit,

Yes, RefTreeAnalyser recognizes dynamic arrays and lambda functions.

Comment by: wiensha (1-10-2022 09:44:00) deeplink to this comment

Change

Download RefTreeAnalyser (Free demo!!!) V3.0 (Build 187, Updated September 22, 2022, downloaded: 21.226 times)

Into

Download RefTreeAnalyser (Free demo!!!) V3.1 (Build 187, Updated September 22, 2022, downloaded: 21.226 times)

(V3.0 should be V3.1 on this page)

Comment by: Jan Karel Pieterse (3-10-2022 09:48:00) deeplink to this comment

Well spotted Wiens, thanks.

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.




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