Most Valuable Professional

View Jan Karel Pieterse's profile on LinkedIn subscribe to rss feed
Subscribe in a reader

Subscribe to our mailing list

* indicates required

File crashes Excel!!

Save my workbook!
The best tool for salvaging problematic workbooks.


Excel VBA Masterclass (English)
Excel VBA for Financials (Dutch)

Third party tools

Speed up your file

The best tool to optimise your Excel model!

Repair your file

Stellar Phoenix Excel Repair
Best tool to repair corrupt Excel sheets and objects
Home > English site > Products > RefTreeAnalyser > Version information
Deze pagina in het Nederlands

RefTreeAnalyser versions

Current Version

Buy RefTreeAnalyser now!

The most recent version is is available for download here, which features the following additions/changes:

RefTreeAnalyser works in all Excel versions as of Excel 2007 (both 32 and 64 bit is supported). For Excel 2003 an older version is available.

Update Information

Build number Changes
  • Included Help file and a Help button on both the find references and the find circular references screens
  • Added an entry on the cell right click menu to access the tool.
  • Hotkeys to start the tool
  • Improved reporting
  • Fixed a minor issue regarding double operators such as >=
  • Fixed a small screen resizing problem
  • RefTreeAnalyser now handles structured references to Excel 2007-2013 tables
  • Prevent error message when workbook has protected worksheets
  • Show message if no precedents/dependents have been found
  • RefTreeAnalyser does not error out when started whilst editing a cell
2.0 011
  • 64 bit version
  • Improved circular reference algorithm
  • Error tracing added
  • Time range calculations
  • Check range for inconsistent formulas
  • Sheet statistics added
2.0, 012
  • It is now possible to change the hotkeys.
  • I have also made sure that when an update is available, the help file is automatically updated.
2.0, 013
  • Fixed a problem related to setting hotkeys.
  • Made sure form position is remembered (and can be reset).
2.0, 014
  • Fixed a compile error that only Excel 2003 exhibits.
2.0, 015
  • Fixed that the About screen does not show proper registration status
2.0, 017
  • Fixed some problems related to Excel 2003.
2.0, 018
  • Fixed some problems related to Excel 2003.
2.0, 019
  • Fixed that the about button in Excel 2003 sometimes opened the About screen of another add-in.
2.0, 020
  • Added a separate add-in file (.xla) for Excel 2003 and before.
2.0, 021
  • Fixed an Excel 2007 issue
2.0, 022
  • Improved returning to previous selection after closing the tool
2.0, 023
  • Minor bugfix
2.0, 024
  • Prevented unnecessary scrolling
2.0, 025
  • Fixed bug with absolute cell references to multiple columns.
2.0, 026
  • Fixed bug regarding files opened in protected mode
2.0, 027
  • Minor bugfix
2.0, 028
  • Fixed a compile error in Excel 2003
2.0, 029
  • Fixed a bug for Excel 2013, prevents messages being covered by the application's screens
2.0, 030
  • Fixed bug where RefTreeAnalyser removed the License registration information when unchecking the add-in
2.0, 031
  • Fixed a bug for Excel 2013, preventad another message from being covered by the application's screens
2.0, 032
  • Improved the error trace tool and the functioning of the stop button.
2.0, 033
  • Important update: fixed some bugs in the multi-level precedents searching
2.0, 034
  • Minor bugfix regarding Excel 2013 windows.
2.0, 035
  • Improved tracing errors function
2.0, 036
  • Improved reporting
2.0, 037
  • Added a new option to the tool: Visualize precedents. The precedents of a cell are visualised directly on the worksheet, a vast improvement on the built-in show precedents option.
2.0, 039
  • Fixed a bug pertaining to Excel 2003 and 2007
2.0, 040
  • Visualize now also available for Excel 2003
2.0, 041
  • Added an option to change the visualisation colors
2.0, 042
  • Visualization: Improved placement of pictures of cells which are out of view
2.0, 043
  • Fixed an issue with opening empty workbooks in 64 bit Excel 2013
  • Fixed issue with leaving an entry in the find dialog
2.0, 044
  • Added new Object References option
2.0, 045
  • Objects are now also analysed when tracing dependents and precedents.
2.0, 046
  • Fixed a bug regarding Visualisation
2.0, 047
  • Beta version
2.0, 048
  • Made object search optional in find precedents/dependents
2.0, 049
  • Improved progress bar for searching objects, prevented blank workbook when opening files from network shares
2.0, 050
  • Improved reporting by adding hyperlinks; fixed some bugs
2.0, 051
  • Added hotkey support for Objects and Check Formulas.
2.0, 052
  • Added double-click functionality to the treeviews
2.0, 053
  • Added ability to disable hotkeys
2.0, 055
  • Added highlight formula blocks on "Check formulas" dialog, Improved performance of Check formulas.
2.0, 056
  • Fixed bug regarding local range names
2.0, 057
  • Small optimisations
2.0, 058
  • Changed registration behaviour, registered copies no longer access the Internet to check for registration
2.0, 059
  • Fixed a compile error
2.0, 060
  • Added the "Formula Report" functionality
2.0, 061
  • Fixed bug regarding startup screen not appearing in Excel 2013
2.0, 062
  • Fixed a bug regarding registration of hotkeys
2.0, 063
  • Fixed bug regarding startup screen not appearing in Excel 2013 (caused by an Office 2013 Update)
2.0, 064
  • Fixed a window resizing bug
2.0, 065
  • Improved calculation timer
2.0, 066
  • Improved grouping in the Objects dialog, fixed screenupdating bug
2.0, 067
  • Avoid trying to remove arrows when no arrows have been added
2.0, 068
  • Added Alt key support for hotkeys
2.0, 069
  • Bug gefixt (treeview reageert niet)
2.0, 070
  • Fixed a small bug
2.0, 071
  • Fixed small issue with formula report and worksheet names that resemble dates
2.0, 072
  • Fixed window handling for Excel 2013 and up
2.0, 073
  • Fixed small bug regarding editing the formula in the dialog
2.0, 075
  • Added unprotecting/protecting of workbook and worksheets, Fixed issue with removal of arrows
2.0, 076
  • Fixed error message when quitting Excel without open workbooks.
2.0, 077
  • Fixed asking for passwords when saving files
2.0, 078
  • Fixed hang when using check formulas
2.0, 079
  • Fixed a number of windowing problems related to Excel 2013 and 2016, fixed a bug in the Find Object references
2.0, 080
  • Improved performance finding dependents, improved how Objects are listed
2.0, 081
  • Improved error tracing, fixed bug regarding sheetnames with a pipe character
2.0, 082
  • Fixed a bug regarding whole-column references
2.0, 083
  • Fixed a bug in the sheet stats module
2.0, 084
  • Fixed objects bug and added automatic update of precedents/dependents tracking
2.0, 085
  • Fixed bug regarding setting errortracing hotkey
2.0, 087
  • VBA code signed with new certificate
2.0, 088
  • Added an off-sheet references report which visualises the inter-sheet formula links of your workbook
2.0, 091
  • Fixed a number of bugs
2.0, 092
  • Fixed a bug related to Excel 2013 and 2016; Improved Off-sheet references report to include checks for Tables and range names
2.0, 093
  • Fixed a bug pertaining to unhiding worksheets
2.0, 094
  • Fixed a bug causing crashes of Excel 2013 and 2016 when other certain add-ins are loaded
2.0, 096
  • Added back double-click functionality to the treeview (same action as clicking Do ActiveCell
2.0, 097
  • Improved scrolling within a table
2.0, 098
  • Added a new function: Display formula as a mathematical equation
2.0, 099
  • Fixed small bug in report formulas
2.0, 100
  • Fixed bug regarding visualising merged cells
2.0, 101
  • Added workaround for Excel bug affecting the "Display Equation" function in non-English Excel versions
2.0, 102
  • Fixed bug changing objects hotkey; added work-around for people having issues with the Visualise option; fixed an issue with selecting objects from the treeview.
2.0, 103
  • Fixed not selecting off-sheet references from the precedents/dependents trees (bug introduced in build 102)
2.0, 104
  • Improved scrolling the selected cells into the viewable area of the screen
2.0, 105
  • Fixed bug, Pivottables were not listed when pointing to a table name
2.0, 106
  • Fixed issue with short-cut keys not responding immediately after openening Excel
2.0, 107
  • Fixed bug where range names were no longer listed (introduced with build 105)
2.0, 108
  • Added jump to pivotsource when you trace precedents when in a pivottable
2.0, 109
  • Fixed repositioning of screen when re-activating dialog from Excel
2.0, 110
  • Build 109 caused 64 bit versions of Excel to crash, this is fixed in this build.
2.0, 111
  • Improved performance for Excel 2013 and 2016
2.0, 112
  • Fixed progress bar problems (Excel 2013, 2016) by enabling user to use taskbar instead
2.0, 113
  • Finally fixed an intermittent issue with the Visualize functionality on Excel 2016
2.0, 114
  • Improved performance on analysing conditional formatting formulas
2.0, 115
  • Fixed a small bug only occurring when you have a chartsheet selected
2.0, 116
  • Enabled cyrrilic (and other non-western) character set for table names
2.0, 117
  • Improved working of Tile option placing the dialog next to the Excel window, Improved reporting of formulas
2.0, 118
  • Added an option to settings to enable or disable automatic unhiding of worksheets
2.0, 119
  • Added Report Function Count, which reports a count of all Excel functions used in your model
2.0, 120
  • Fixed a small bug
2.0, 121
  • Improved performance of Dependents search
2.0, 122
  • Fixed a bug with finding Dependents introduced with build 121
2.0, 124
  • Updated "phone home" for registration
2.0, 125
  • Included Array formulas in circular reference checks
2.0, 126
  • Fixed runtime error due to third-party add-ins when checking if tool is installed
2.0, 127
  • Adapted site addresses to use https
2.0, 128
  • Added code to improve updating experience
2.0, 129
  • Improved performance of formula checking and reporting significantly
2.0, 130
  • Not published
2.0, 131
  • Improved display of Object dependencies, improved tiling windows next to Excel.
2.0, 132
  • Updated the tool so it works with the new Excel Data Types (Geography and Stock) and with the new Dynamic Array references
2.0, 133
  • Not published
2.0, 134
  • Improved finding, displaying and reporting of cell references used by Objects
2.0, 135
  • Fixed an issue with finding references in chart SERIES formula
2.0, 137
  • Fixed a visualization issue
2.0, 138
  • Fixed a registration issue
2.0, 139
  • Changed check for registration
2.0, 140
  • Enabled selecting pivot table belonging to pivot chart
2.0, 141
  • Couple of bugs fixed
2.0, 142
  • Fixed a bug regarding handling of string literals in a formula
2.0, 143
  • Improved the Check Formulas interface

Buy RefTreeAnalyser now!


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


Comment by: Dave Hockin (7-11-2013 18:35:49)

Bug v2.041 ?
Using excel 2010, Windows 7
Was working fine for a couple of weeks, then today created an issue for excel where the clipboard was emptied on sheet deactivate. Could copy on one sheet, but clipboard empty for paste when on different sheet or between books. I disabled the addin and paste issue was resolved. Reactivate--same problem, Deactivate all is good again, then on reactivate got the New Version (42) avail msg. I accepted it and now working.
Trail of notes for you just so you are aware if it occurs for others.


Comment by: Jan Karel Pieterse (7-11-2013 19:55:15)

Hi Dave,

Thanks. That was one of the reasons for publishing build 42 indeed.


Comment by: VJ (26-9-2014 02:51:25)

Is there a way to show the exact cells being added through a Sumif/ Sumifs formula. Currently the Find precedent command is showing the range being evaluated but not the exact cells being added


Comment by: Jan Karel Pieterse (26-9-2014 11:48:10)

Hi VJ,

I'm afraid that is not in the current scope of the tool. I do like the idea, but it would require quite a lot of logic, since one would want to make this as generic as possible (so not just for SUMIFS).


Comment by: Jon Spain (17-4-2015 16:38:15)

Hi, I saw RefTreeA on NrExcel, I know your name and I've just placed an order for my own laptop. Is a separate license for my own PC needed, please?



Comment by: Jan Karel Pieterse (17-4-2015 22:12:00)

Hi Jon,

The license is personal so you can use it on any system as long as it isn't at the same time :-)


Comment by: Brian (1-3-2017 20:43:37)

How can I eliminate the utility? When I have an Excel spreadsheet linked to an AutoCAD drawing I get an error message, but both programs seem to be working right. The exception is that the AutoCAD file size increases by 10X anytime I open a drawing file once the Excel file has been linked to it. So I need to get rid of it. Can you help me with this?


Comment by: Jan Karel Pieterse (2-3-2017 10:23:26)

Hi Brian,

Go to File, Options, Add-ins tab. Click the Go button and uncheck the add-in.
Odd though, the utility is not supposed to make any changes to your files so I am surprised it somehow does?


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:

Please enter your name (required):

Your e-mail address (optional, will only be used to inform you when your comment is published or to respond to your question directly):

Your request or comment (max 2000 characters):

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

I give permission to process this data and display my name and my comment on this website accoring to our Privacy Policy.