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: 2594 times)

Licensed version (requires a license key)

Licensed version of RefTreeAnalyser V1.0 (Build 1.0.26, Updated November 5, 2009, 763k, downloaded: 1780 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: Kristi (2/25/2008 3:26:25 PM)

It would be helpful to see a screenshot of the report...

Comment by: Kevin H. Stecyk (4/7/2008 6:24:23 AM)

I really enjoy using your program. I've been using it steadily, and it certainly
helps reduce the burden of understanding someone else's mess, I mean spreadsheet.

Comment by: Jan Karel Pieterse (4/8/2008 12:53:21 AM)

Hi Kevin,

Thanks!! Much appreciated.

Comment by: John Russell (7/4/2008 8:34:07 PM)

Hi, I have just installed your demo version of RefTreeAnalyzer and on opening Excel
I get the following error:

Oops, An error has occurred in RefTreeAnalyzer
Error:
Error 13: Type mismatch in modMenu.CreateMenu
Abort - Retry - Ignore

Retry doesn't help so I have gone for Ignore and it appears to work, although it
displays my RC references as A1 refs which is confusing.

I am running Excel 2003 SP3, XP SP2.

Would appreciate any suggestions you can offer.

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.

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.