Subscribe
in a reader
RefTreeAnalyser: The ultimate Excel Formula Auditing tool
Excel formula auditing taken to the next level!
Features:
- Easy Auditing of formula dependents and precedents, including object dependencies (charts, pivot tables, form controls, Validation formulas, Conditional formatting formulas, etcetera)
- Find circular references (yes, all of them!)
- Trace errors
- Time your workbook calculation for each worksheet to find bottlenecks
- Check columns for formula inconsistancies
Ordering
A single user license for RefTreeAnalyser costs € 30 (excluding local VAT).
A license includes:
- Installation and use of the tool on two computers
- One year of free updates.
Prices
| Number of licenses | Price per licence |
| 1-10 | € 30.00 |
| 11-50 | € 23.00 |
Contact me if you'd like to order more than 50 licenses
Free Download
Use the links below to download the tool.
The tool will work without a license code but with (only slightly) limited functionality. After purchasing a license, you can simply enter the license code into the tool's settings dialog. The limitations will be removed instantly.
Current Excel versions (Excel 2007 and up)
Download RefTreeAnalyser for Excel 2007 to 2016 (Free demo!!!) V2.0 (Build 127, Updated May 24, 2018, downloaded: 11,852 times)
Excel 2003
Please note that the 2003 version will no longer be updated!
Download RefTreeAnalyser for Excel 2003 (Free demo!!!) V2.0 (Build 082, Updated Dec 15, 2015, downloaded: 1,593 times)
Blocked files problem
Recently (I write this in August 2016), Microsoft has "enhanced" security and is now blocking any files that are downloaded from the internet. This means that any add-in you try to open after downloading will simply not open in Excel (without display of a warning message!). To resolve this, follow these steps:
1. Copy the add-in from the zip file to any folder
2. Right-click the xla(m) file and choose properties:
3. Click the Unblock button:
Money back guarantee
If you are in any way dissatisfied with RefTreeAnalyser, contact me within 30 days after your purchase and I'll issue a refund.
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, the must-have expansion of your Formula tab of the Ribbon!
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. RefTreeAnalyser makes tracing precedents and dependents a lot easier than Excel's built-in tools. Read more about RefTreeAnalyser.
Supported Excel versions
RefTreeAnalyser is designed to work with Excel 2000 and up, including all 64 bit Excel versions.
More information
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
Comments
Showing last 8 comments of 177 in total (Show All Comments):Comment by: Dave (3/2/2018 9:26:25 PM)
Version 2.0 Build 124 Registered user
Sample formula : =CCA!J314+SUM(CapEx!$J$702:CapEx!J702)
Formula is on my "Taxes" sheet.
Precedent reported for CCA cell but not for the sum range on CapEx sheet.
Excel's formula precedent will report this as 3 precedents and RTA reports 1 precedent. Is this a limitation of your ability in RTA to trace or is there a fixable bug ?
Comment by: Jan Karel Pieterse (3/5/2018 10:18:03 AM)
That is indeed a bug, but your syntax is rather unusual. If you change the formula to this RTA will pick it up as expected:
Comment by: Kirran Sky (3/9/2018 3:24:34 PM)
Any chance you can update to pick up structured references?
e.g. =Table_Name[[#Totals],[Jan-18]] throws out an error.
Comment by: Jan Karel Pieterse (3/9/2018 3:57:52 PM)
It should do so, yours appears an exception :-(
Comment by: Rene (5/13/2018 5:04:23 PM)
I all of a sudden started to receive a "Run-time error '13': Type mismatch.
The RefTreeAnalyser still appears on the Ribbon but I cannot use its functionality anymore.
Help button or "Time Selected Cells" still works but most other buttons result in the above error message and upon clicking Debug Excel crashes.
I already tried deinstalling and virtually all security, macros settings etc. are set to lowest level in Excel.
Thanks
Comment by: Jan Karel Pieterse (5/14/2018 7:25:32 AM)
Which version are you using?
Comment by: Rene (5/14/2018 10:53:45 AM)
RefTreeAnalyzer Version 2.0 Build 125, Release 2018-05-02.
I am using Office 2010.
The add-in works fine on different computers that I tried, so I might have messed something up in Excel that I cannot see yet.
E.g. I switched recently the language pack but switching back didn't change anything either.
I think it is somehow related to the Ribbon. When I tried to disable all other add-ins, the Add-In Ribbon pane with some add-ins in it remained and I couldn't delete them. They were neither found in the Add-In folder (the one through the Excel / Tools/ Options / Browse function) nor could I get rid of them by deleting my entire Excel customization, i.e. by deleting in the registry the "Options" folder under: HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel.
Deleting the entire 'Excel' folder didn't help either.
I then deleted the entries on the Add-In Ribbon pane manually with a right, but still no success.
So I've run out of options now what to try to get it back to work (other than completely resetting / repairing Office).
(The add-in actually did work on my computer a few days ago.)
Any suggestions welcome.
Thanks
Comment by: Jan Karel Pieterse (5/14/2018 11:03:36 AM)
Download the latest version, I expect the issue will be resolved.
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.