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 inconsistencies
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 license |
| 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 135, Updated October 31, 2018, downloaded: 12,963 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,866 times)
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 187 in total (Show All Comments):Comment by: Thomas Plagwitz (6/18/2018 11:46:17 PM)
I have been a happy customer of RTA for a while, but now need to automate running it over a large number of Excel files.
However, I found that whatever I dim the control parameter as:
Dim oControl as Object ' Variant ' iRibboncontrol
the following line will crash my Excel (2010) :
Application.Run "'reftreeanalyserxl.xlam'!rxreftreeFormulaCheckAllSheets", oControl
Any pointers?
TIA,
Tom
Comment by: Thomas Plagwitz (6/19/2018 6:23:27 AM)
Excel 2016 won't crash, but returns "Unexpected error (40182)", no matter what datatype oControl is declared as.
Also tests the same with another RTA procedure:
I am trying to follow Ron de Bruin's Application.Run methodology here. Not using oControl just gives 449 "argument not optional", but at least my base syntax seems correct.
Comment by: Jan Karel Pieterse (6/19/2018 10:29:57 AM)
You can invoke that report using:
Comment by: Thomas Plagwitz (6/25/2018 4:59:51 AM)
Is it possible, however, to turn off the alert "Timing formula calculation seems to take long, skip for worksheet", either default to yes or even skip timing for all worksheets? I have not found a setting in the PDF documentation, nor another way to suppress or OK this dialog.
Also, could you share the internal equivalents for the 2 ribbon commands rxreftreeListAllSheetStats and rxrtFormulaCheckSheetsRefs.
Thanks again, tom
Comment by: Gareth Morgan (10/16/2018 6:47:15 PM)
Comment by: Jan Karel Pieterse (10/17/2018 9:54:33 AM)
Well, yes and no.
No: your license stays valid, it is just the updating which expires.
Yes: If you want another year of updates you need a new license.
Comment by: John Busbee (10/20/2018 4:44:18 PM)
Comment by: Jan Karel Pieterse (10/22/2018 10:10:57 AM)
I'm afraid there is no Mac supported version.
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.