Excel formula auditing taken to the next level!
Content
Free Download
Download RefTreeAnalyser (Free demo!!!) V3.1 (Build 212, Updated Aug
22, 2024, downloaded: 25.813
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
-
Why RefTreeAnalyser?
-
Screenshots of RefTreeAnalyser
-
Version information
-
Operating instructions
