RefTreeAnalyser: Formula Auditing tool for Excel
Excel formula auditing taken to the next level!
Content
- Free Download
- Video
- Ordering licenses
- Money back guarantee
- What is RefTreeAnalyser?
- Features
- More information
Free Download
Download RefTreeAnalyser (Free demo!!!) V3.1 (Build 214, Updated Oct 7, 2024, downloaded: 25.943 times)
By downloading the file, you give your consent to the
license conditions.
After downloading the file, please read the readme.txt file, it contains
important installation instructions.
In addition, please read:
Excel add-ins fail to
load
The tool will work without a license code but with (only slightly) limited functionality.
After purchasing a license, you simply enter the license code into the tool's settings dialog. The limitations will be removed instantly.
Supported Versions of Excel
- Windows: Microsoft 365, 2021, 2019, 2016, 2013, 2010, and 2007
- Mac: Microsoft 365 (please note that the circular reference detection does not work on Mac Excel)
- Supports both 32 and 64 bit Office
Older versions of RefTreeAnalyser
If you need an old version of RefTreeAnalyser, please contact me.
Video
Here is a video demonstrating most features of RefTreeAnalyser
Ordering licenses
A license includes:
- Installation and perpetual use of the tool on two computers
- One year of free updates
Here are the license conditions
Permanent licenses are available upon request
Prices
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?
RefTreeAnalyser is an Excel add-in (written in VBA), which helps you audit formulas in Excel files. If you have ever had to untie the spaghetti-knots of a large Excel workbook's formulas, then you know what a nightmare this can be.
With this formula auditing add-in, 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.
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 (Excel for Windows only!)
- Trace errors
- Find out which cells are used by all kinds of things in your file: pivot tables, charts, conditional formatting, data validation, forms and ActiveX controls and etcetera.
- Generate a table of content containing not just your worksheets, but also your charts, pivot tables and (form) controls
- Time your workbook calculation for each worksheet to find bottlenecks
- Check columns for formula inconsistencies
More information
Comments
Showing last 8 comments of 239 in total (Show All Comments):Comment by: Mal Z (6-4-2023 21:28:00) deeplink to this comment
Hi, I just bought a license. For the Tracing Cell dependents and precedents, how do I fix the Levels to a certain number (e.g. 5) automatically without having to toggle it each time the window opens?
Comment by: Jan Karel Pieterse (6-4-2023 23:08:00) deeplink to this comment
Hi Mal,
I'm afraid you currently can't. I decided to reset to 1 a long time ago because otherwise the tool may be very slow for larger models. Perhaps this calls for adding this as an option in the next update.
Comment by: Mal Z (6-4-2023 23:46:00) deeplink to this comment
That'd be a great addition to the next update - perhaps in the main settings menu, letting the user tick a box for a default Level they can choose.
Thanks a lot anyway!
Comment by: Jan Karel Pieterse (7-4-2023 11:27:00) deeplink to this comment
Hi Mal,
Noted, thanks!
Comment by: Mohamed GadAllah (31-10-2023 09:45:00) deeplink to this comment
Just installed a fresh clean copy of Microsoft 365 and then enabled the add-on file.
I get this error:
https://i.imgur.com/sYY36Xo.png
Comment by: Jan Karel Pieterse (31-10-2023 09:49:00) deeplink to this comment
Hi Mohamed,
That is strange. I don't get that error. Which exact version of Excel do you have?
Comment by: Kirran Sky (13-8-2024 12:17:00) deeplink to this comment
Hey Jan,
The download seems to be corrupted at the moment.
Kind regards,
Kirran
Comment by: Jan Karel Pieterse (13-8-2024 15:01:00) deeplink to this comment
Hi Kirran,
Try downloading it after temporarily turning off your anti-virus software, it tends to false-flag it on occasion.
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.