RefTreeAnalyser: The ultimate Auditing tool

For Microsoft^® Excel^®

Excel formula auditing taken to the next level!
Easy Auditing of formula dependents and precedents.

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!

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. Read more about RefTreeAnalyser.

Purchase a license

The table below shows the current license costs for The RefTreeAnalyser:

Number of licenses purchased	Price per license	Other currencies (approximate prices! Exchange rates may vary daily):
1-50	€ 15.00 (Note that you'll be able to pay in your local currency if you use this button, Paypal will handle the conversion for you.)	USA:$ 20 UK: £ 14 Canada: CAD 24 Australia: AUD 30
51 and up	Contact me

Note: Prices are excluding local taxes. According to EU rules, client will be responsible for paying any local taxes due.
For Dutch customers: BTW is included.

Please use the buy now button above for purchasing licenses or contact me for more information.

Download

Two versions are available for download:

Demo version
Licensed version

The demo version is fully functional, but has some restrictions:

It shows a nag screen every time you launch the tool to analyse a cell
Reporting is disabled
The tool is limited to 1 level.

Download either version below.

Demo version

Demo version of RefTreeAnalyser V1.0 (Build 1.0.26, Updated November 5, 2009, 758k, downloaded: 2682 times)

Licensed version (requires a license key)

Licensed version of RefTreeAnalyser V1.0 (Build 1.0.26, Updated November 5, 2009, 763k, downloaded: 1829 times)

More information

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

Comments

All comments about this page:

Comment by: Jeff K (9/22/2008 4:47:46 PM)

Hi,

This is a really great tool. I just started using the paid version, and it is
incredibly helpful for me to debug spreadsheets.

I believe that there is a defect whereby a sheet name containing a single quote
(e.g., FTE's_Single Site) is not 'auditable' (i.e., when a cell from this sheet
shows up in Dependants, clicking on it does not take me to the cell). When I remove
the single quote from sheet name, all works fine. Please fix, if possible.

Thanks.

Comment by: Jan Karel Pieterse (9/23/2008 1:25:00 AM)

Hi Jeff,

Thanks for the kudo's.
I'll look into the quote problem, definitely a bug.

Comment by: Norm (5/26/2010 7:46:38 AM)

I purchased your reftree analyser Feb 19 2009.
Even with it's quirks, it's a handy add-in to have around.

Is there anyway I can determine the license no. of the installed program.

I'm transitioning to a new computer and want to re-install reftree.

Comment by: Jan Karel Pieterse (5/26/2010 8:09:52 AM)

HI Norm,

You should have an email from 'webmaster at jkp-ads.om' which contains your registration code.
If you misplaced the message, send me an email (see address below) and I'll re-send it to you.

Comment by: Sue (7/26/2010 9:21:21 AM)

I bought reftreeanalyser last year and find it very useful.

Occanionally Excel crashes and the menu has dissapeared. However I but cannot get it to appear anymore though there is no error meesage when I download it and enter the licence key. And Reftreelauncher is listed under available Excel addins.

I am using a new windows 7 machine now, and office 2007.

Grateful for any suggestions here,

Sue

Comment by: Jan Karel Pieterse (8/16/2010 3:10:05 AM)

Hi Sue,

Maybe the addin has been disabled by Excel. Check:

Office button, Excel Options, Addins tab, in the dropdown, select "Disabled Items" and click the Go button. See if the reftreeanalyser is in that list. If so, select and click enable.

Comment by: Nikhil Mehta (8/23/2010 12:45:35 AM)

I am using your tool for MS Excel spreadsheet in Windows. Do you have the same tool for MS Excel for MAC.

Comment by: Jan Karel Pieterse (8/23/2010 3:53:06 AM)

Hi Hikhil,

I'm sorry, this addin is only available for the Windows version of Office.

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.