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
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 (Free demo!!!) V2.0 (Build 159, Updated Mar 8, 2021, downloaded: 19.200 times)
After downloading the file, please read the readme.txt file, it contains important installation instructions!!!
Excel 2003
Please note that the 2003 version will no longer be updated!
Download RefTreeAnalyser for Excel versions 2003 and older (Free demo!!!) V2.0 (Build 082, Updated Dec 15, 2015, downloaded: 2.836 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 206 in total (Show All Comments):Comment by: john (4-1-2020 10:42:00) deeplink to this comment
The addin is perfect but can you add evaluate formula option(like in excel) in this addin
Comment by: Jan Karel Pieterse (6-1-2020 11:49:00) deeplink to this comment
Hi John,
Thank you for the suggestion!
Comment by: Alejandro (14-7-2020 22:14:00) deeplink to this comment
Hi, this license this sale in chile?, exist one representative in chile for companies?
Comment by: Jan Karel Pieterse (18-7-2020 19:10:00) deeplink to this comment
Hi Alejandro,
You can buy the license directly from this website.
Comment by: Gearoid (1-10-2020 16:01:00) deeplink to this comment
Hi there,
Does this work with Excel 365. Can I trial it before I buy it?
Thanks
Comment by: Jan Karel Pieterse (2-10-2020 16:28:00) deeplink to this comment
Hi Gearoid,
Yes indeed it works with any Excel version (for Windows!) as of Excel 2007 up to and including Excel 365.
You can download the tool and try it as it automatically works in demo mode with limited functionality.
Once you're happy with the tool you can go back to this page, purchase a license (sent to you by email).
You can enter the license code into the settings dialog of the tool and it will unlock into the full version automatically.
Comment by: Matías Pavez (8-4-2021 20:51:00) deeplink to this comment
I have a Problem with the precedents function.
It doesnt work in this last update!
Comment by: Jan Karel Pieterse (9-4-2021 11:51:00) deeplink to this comment
Hi Matias,
I'm sorry to hear you are having an issue. Does it help to open the settings screen and click the Rest Forms button?
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.