RefTreeAnalyser: Formula Auditing tool for Excel
Content
- Free Download
- Video
- Ordering licenses
- Money back guarantee
- What is RefTreeAnalyser?
- Features
- What Other People Say about RefTreeAnalyser
- More information
Free Download
Download RefTreeAnalyser (Free demo!!!) V4.0 (Build 218, Updated Nov 15, 2024, downloaded: 26.323 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.
Buy now (Paypal and all major credit cards supported)
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, 2024, 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 requestBuy now (Paypal and all major credit cards supported)
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.
Buy now (Paypal and all major credit cards supported)
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
- Insert a Table of Content
- Navigate worksheets and tables using a ribbon drop-down
- Includes two of my other popular add-ins: FlexFind and Name Manager and keeps them updated
What Other People Say about RefTreeAnalyser
Here is some feedback I received about RefTreeAnalyser:
- "I have been using for many many years. Easy to use and does a great job on all the references such as precedents/dependants Report Formulas is very handy, Function Report is great as reminds me of functions when listed. Its a must have tool for working on complicated spreadsheets with lots of formulas"
- "It works great, makes analyzing any workbook it whichever way you require a cinch. I can seriously advice it to all VBA coders and developers since it simplifies documenting and checking. I started with the Beta version and minor, mostly cosmetics, glitches I reported, and these were almost directly updated on-the-fly."
- "App is very responsive, not bloated with unnecessary features, does the core task well, frequent updates, thoughtful developer notes, efficiency analysis tools like "all sheet stats" are interesting. As an expert modeler / professional large financial transaction model architect focused on squeezing every ounce of efficiency, speed, and responsiveness, I rely on many of the features when auditing/analyzing my models. Easily my favorite tool vs competitors. I use my own personal shortcuts / macros for formatting so the lack of formatting macro bells and whistles (I turn these off) is a positive rather than a negative"
- "'All Sheet Stats' and 'Time Selected cells' functions"
- "1. The report of dependent cells shown in blocks of range
2.Circular refs report" - "Ability to easily see precedents in complex formulas"
- "Ability to trace formulae - this is an essential - together with evaluating each cell individually"
- "all sheet stats higlight cells price...."
- "being able to click on a named variable in the precedents list and have the active cell change to that location"
- "Calc Time, Precedents/Dependents" "clear self-explanatory layout"
- "Ease of tracing formulas"
- "Ease of use to see complex cells relationships"
- "enhanced display of successors and precidents"
- "Everything :)"
- "Flexibility to adapt it as I like it better and responsiveness (some other tools are a little bit slow)."
- "From tools which work I like speed measurement - All Sheets stats. And of cours Clear Arrow :-|"
- "Great auditing feature" "Highlighting"
- "I like seeing the values next to the addresses - and the ability to drill down or back up"
- "Intuitive. Great documentation. Useful functions."
- "It keeps improving. "
- "It meets my needs. I have some older spreadsheet/VBA tools that did not follow some of the better code design methods. The tool helps me to find and reduce inefficient code "
- "It saves me a lot of time on formula analysis"
- "It works great when it does. However, for large excel files and complicated models I do get excel crashing with automation errors and I loose time and work already done"
- "It works when needed and stays in the background when not needed. It keeps improving. "
- "love the equation display table of contents"
- "Offering better visibility into formulas than the build in features in Excel"
- "references check"
- "Significant improvement over the standard tool to trace precedents and dependent cells."
- "The 'Check formulas' feature."
- "The 'Check Formulas', 'Trace Precedents / Dependents', and 'Object References' features have all proved incredibly useful."
- "the overview of the dependents"
- "The releases over the last year or so have been rock solid stable. The tracking window stays out of the way until needed. The tool has adopted to the challenges of tracking the table column reference syntax. The tool has expanded ability to document formulas and ranges for control purposes."
- "The user experience tool keeps improving and evolving."
- "ToC generation with hyperlinks to all sheets is great as I have many files with lots of tabs."
- "Tool runs fast and provides very relevant information especially if you are doing Excel modeling work or taking over a complex spreadsheet from someone. Output reports are clear and very helpful to identify bottlenecks and overall file inter-dependencies."
- "Trace Errors"
- "Tracking cell dependents and precedents"
- "Understanding formulas"
- "Very detailed and easy to use"
- "Very hepful"
- "very practical earlier this year on a very complex client workbook no structured refs or named ranges just cell refs and i tried to use the formula analyser from a certain well known workbook speed add-in and couldn't follow it and for the moment forgot about your tool which is sp more visual and better"
- "Visualizing The dependents. "
More information
Buy now (Paypal and all major credit cards supported)
Comments
Showing last 8 comments of 245 in total (Show All Comments):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.
Comment by: Arjen (6-11-2024 17:02:00) deeplink to this comment
Hi Jan Karel Pieterse,
when I want to use simular fucntionality in my add-in, I noticed that the tree-node work on Microsoft windows Common control 6.0 library, except this is not available in an add-in and also no longer maintained by Microsoft, so I needed to switch to list boxes. It is still working fine, but it doesn't look as nice.
Did you had the same problem?
Comment by: Jan Karel Pieterse (6-11-2024 18:05:00) deeplink to this comment
Hi Arjen,
Yes I did, which is why I created this: https://jkp-ads.com/articles/treeview.asp
Comment by: Diederik van Kolfschoten (8-11-2024 16:14:00) deeplink to this comment
Dag Jan Karel,
Mijn IT afdeling gaf aan dat er in de XLAM mallware zou zitten en heeft de reftree analyzer verwijderd. zijn daar meer meldingen van?
groet,
Diederik
Comment by: Jan Karel Pieterse (8-11-2024 19:11:00) deeplink to this comment
Hoi Diederik,
Dat is een false positive, dat gebeurt vaker helaas. Maar de file is gecheckt en in orde!
Comment by: Anton (19-11-2024 20:46:00) deeplink to this comment
This Add-in (Version 4) needs Internet? For Licensing or check licensing? Because (Version 3) works without Internet.
Comment by: Jan Karel Pieterse (19-11-2024 22:34:00) deeplink to this comment
Hi Anton,
Yes so did the previous 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.