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

Licensed version (requires a license key)

Licensed version of RefTreeAnalyser V1.0 (Build 1.0.26, Updated November 5, 2009, 763k, downloaded: 1454 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: Doug Glancy (12/17/2007 1:49:47 PM)

Jan Karel,

Today I had need for such a tool so I downloaded the demo. I clicked on a cell and
chose "dependents". It started going through every row of another sheet which has
about 1,300 rows. It was taking quite a while, so I hit stop and after about a
minute it did. I wonder if Application.ScreenUpdating would speed things up?

I then ran the uninstall from Add/Remove progams. It reported success, but the
2-icon toolbar was still in Excel. When I clicked on the left-hand button, I got the
same message I'd get if I chose Tools>Formula Auditing>Trace Dependents. I deleted
the toolbar in Tools>Customize and it's gone for good.

I have 2 versions of XL on this computer 03 and 07. The toolbar is only present in
03 - I'm not sure if it was ever installed in 07.

I thought you might like to know this.

Doug

Comment by: Jan Karel Pieterse (12/17/2007 10:24:07 PM)

Hi Doug,

Well, some food for thought there obviously. Screenupdating IS turned off as far as
I know, but I'll double check. I also know about the toolbar problem and this is
scheduled to be fixed in a later version.
In 2007 you should look on the Formulas tab, no toolbar there.

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.