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 (yes, all of them!)
  • 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 Windows Excel versions: Microsoft 365, 2021, 2019, 2016, 2013, 2010, and 2007. Supports both 32 and 64 bit Office.

Download RefTreeAnalyser (Free demo!!!) V3.1 (Build 189, Updated November 2, 2022, downloaded: 21.553 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 single user license for RefTreeAnalyser costs € 35 (excluding local VAT).

A license includes:

  • Installation and perpetual use of the tool on two computers
  • One year of free updates.

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 227 in total (Show All Comments):

 


Comment by: Mohamed GadAllah (26-11-2022 11:14:00) deeplink to this comment

If the info may affect your solution.
Any Excel add-in file I used to placed it here:
C:\Users\UserName\AppData\Roaming\Microsoft\AddIns
Which is this in my case:
C:\Users\Mohamed\AppData\Roaming\Microsoft\AddIns
Shown here:
https://imgur.com/a/0toSYYA


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

Hi Mohamed,

Have you tried to enter a different character than the question mark in settings for the Visualize options?

If you mostly use the ribbon buttons, you could also just remove that question mark.


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


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].