Home Article index Newsletter

Deze pagina in het NederlandsHome > Products > RefTreeAnalyser >

RefTreeAnalyser Operating instructions

Start the tool from the ribbon of Excel 2007 and up, you will find a group on the Formulas tab:

Or use the cell right click menu:

In Excel 2003, Start the tool from Excel's Tools menu:

or use the toolbar:


Buy RefTreeAnalyser now!


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


Comment by: Jan Karel Pieterse (27-8-2016 19:20:34) deeplink to this comment


Probably the file is blocked due to a recent security update. See: http://www.jkp-ads.com/Articles/excel-add-ins-fail-to-load.asp

Comment by: Apostolos (5-9-2018 22:47:03) deeplink to this comment

Hi Jan Karel,

I get the following message when RefTreeAnalyser tries to update, either automatically or manually:
"Checking for updates has failed: Unable to fetch latest build number from www.jkp-ads.com".

Can you please advise how to resolve?

Many thanks in advance!

Comment by: Jan Karel Pieterse (6-9-2018 09:15:35) deeplink to this comment

Hi Apostolos,

Please download the version from the site and replace your RefTreeAnalyser files on your disk with the ones in the download. I have changes my site from http to https, which causes the update process to fail on the older versions.

Comment by: Apostolos (7-9-2018 17:39:58) deeplink to this comment

Thank you Jan Karel,

Worked like a charm!

Best Regards,

Comment by: Apostolos (11-9-2018 18:17:04) deeplink to this comment

Hi Jan Karel,

I updated RefTreeAnalyser successfully to v2.0 129. While the "Report Formulas" tool worked marvelously in the past, when I am running it now, Column D of the report (headed "Used in"), which includes the address of the ranges where each formula is applied, now shows many "#VALUE!" errors. Further, there are no hyperlinks to the respective ranges, which was an extremely useful functionality of the tool. Do I need to change some kind of setting? I am using the Professional Plus 2016 version.

Best Regards,

Comment by: Jan Karel Pieterse (11-9-2018 18:23:20) deeplink to this comment

Hi Apostolos,

The "UsedIn" column now contains a formula which points to the cells using the formula.

The trick is to use RTA itself to traverse those references, simply by using trace precedents (control+shift+[ short-cut)

Comment by: Wiens (18-4-2020 16:35:00) deeplink to this comment


In the RefTreeAnalyserXL Build 151 there is a typo in the file where the following question is asked during opening of an Excel file after installation:

'This is an unregistered version, updates are diabled. Would you like to purchase a license?'

'diabled' should be 'disabled' in the text.

Comment by: Jan Karel Pieterse (20-4-2020 11:17:00) deeplink to this comment

Hi Wiens,

Thank you!

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, 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.