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 > 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!



Comments

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

 


Comment by: Jan Karel Pieterse (3/31/2016 7:03:05 AM)

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 (8/27/2016 5:39:44 PM)

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 (8/27/2016 7:20:34 PM)

Hi,

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 (9/5/2018 10:47:03 PM)

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!
Apostolos

 


Comment by: Jan Karel Pieterse (9/6/2018 9:15:35 AM)

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 (9/7/2018 5:39:58 PM)

Thank you Jan Karel,

Worked like a charm!

Best Regards,
Apostolos

 


Comment by: Apostolos (9/11/2018 6:17:04 PM)

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

 


Comment by: Jan Karel Pieterse (9/11/2018 6:23:20 PM)

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: 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:

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.