RefTreeAnalyser: The ultimate Excel Formula Auditing tool

For Microsoft® Excel®

Excel formula auditing taken to the next level!

Content

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

Free Download

Supported Excel versions:

  • Windows versions: Microsoft 365, 2021, 2019, 2016, 2013, 2010, and 2007
  • Mac versions: Microsoft 365 (please note that the circular reference detection does not work on Mac Excel)
  • Supports both 32 and 64 bit Office

Download RefTreeAnalyser (Free demo!!!) V3.1 (Build 195, Updated Mar 17, 2023, downloaded: 22.096 times)

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 can simply enter the license code into the tool's settings dialog. The limitations will be removed instantly.

Old versions

If you need an old version of RefTreeAnalyser, please contact me.

Ordering licenses

A license includes:

  • Installation and perpetual use of the tool on two computers
  • One year of free updates
  • Permanent licenses are available upon request

Buy RefTreeAnalyser now!

Prices

Amount
  Price per license
1-10
  € 35.00
11-50
  € 32.00
51-100
  € 29.00
101-300
  € 26.50
301+
  € 24.00

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 RefTreeAnalyser now!

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!

Here is RefTreeAnalyser, your must-have expansion of your Formula tab of the Ribbon!

Screenshot of RefTreeAnalyser Visualize option of RefTreeAnalyser

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 2007 and up, including all 64 bit Excel versions.

More information

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

Buy RefTreeAnalyser now!

 


Comments

Showing last 8 comments of 229 in total (Show All Comments):

 


Comment by: Mohamed GadAllah (28-11-2022 20:44:00) deeplink to this comment

Hi Jan,
remove that question mark solved the issue.

May I continue using the tool for education and personal purposes after 30 days?


Comment by: Jan Karel Pieterse (28-11-2022 22:40:00) deeplink to this comment

Hi Mohamed,

Yes of course!


Comment by: Mohamed GadAllah (29-11-2022 17:34:00) deeplink to this comment

Hi my friend.
Please, what are the limitations ?
Thanks


Comment by: Jan Karel Pieterse (29-11-2022 17:49:00) deeplink to this comment

Which limitations are you thinking of?


Comment by: Mohamed GadAllah (29-11-2022 17:51:00) deeplink to this comment

I mean this line:
"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."


Comment by: Jan Karel Pieterse (29-11-2022 19:57:00) deeplink to this comment

Hi Mohamed,

Limitations like:
- No reporting option on most dialogs
- Only reports the top 3 most used functions
- Displays the settings form regularly
- Less dependency levels


Comment by: Renan Serafim (8-12-2022 03:38:00) deeplink to this comment

I would like to request a trial for myself.


Comment by: Jan Karel Pieterse (8-12-2022 10:50:00) deeplink to this comment

Hi Renan,

There is no need to request a trial, you can simply download the tool using the download link on this page.


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.




To post VBA code in your comment, use [VB] tags, like this: [VB]Code goes here[/VB].