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!

Repair your file

Stellar Phoenix Excel Repair
Best tool to repair corrupt Excel sheets and objects
Home > English site > Products > RefTreeAnalyser > Operating instructions
Deze pagina in het Nederlands

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 33 in total (Show All Comments):


Comment by: Jan Karel Pieterse (31-3-2016 07:03:05)

Hi Stanley,

That is unusual. Perhaps you need to run Excel as an admin for this (though that should not be needed)?


Comment by: C Lee (27-8-2016 17:39:44)

Hi, Jan Karel,

I am currently using Office 365 in Win 10, and it seems that I can't open the file by double clicking the file. Please kindly help, thanks!

Regards, C Lee


Comment by: Jan Karel Pieterse (27-8-2016 19:20:34)


Probably the file is blocked due to a recent security update. See:


Comment by: Apostolos (5-9-2018 22:47:03)

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

Can you please advise how to resolve?

Many thanks in advance!


Comment by: Jan Karel Pieterse (6-9-2018 09:15:35)

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)

Thank you Jan Karel,

Worked like a charm!

Best Regards,


Comment by: Apostolos (11-9-2018 18:17:04)

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)

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)


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.