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  V4.0, build 219. Updated Jan 6, 2025.

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 request

Buy 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

1. Why RefTreeAnalyser?
2. Screenshots of RefTreeAnalyser
3. Version information
4. Operating instructions

Buy now (Paypal and all major credit cards supported)