Excel formula auditing taken to the next level!
- 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
A single user license for RefTreeAnalyser costs € 30 (excluding local VAT)
|Number of licenses||Price per licence|
Contact me if you'd like to order more than 50 licenses
Use the links below to download the tool.
Excel 2007, 2010, 2013 and 2016
Download RefTreeAnalyser for Excel 2007 to 2016 (Free demo!!!) V2.0 (Build 104, Updated Jan 5, 2017, downloaded: 8,553 times)
(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: 634 times)
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.
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.
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.