RefTreeAnalyser versions

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 tables references

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

64 bit version
Improved circular reference algorithm
Error tracing added
Time range calculations
Check range for inconsistent formulas
Sheet statistics added

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.

Fixed a problem related to setting hotkeys.
Made sure form position is remembered (and can be reset).

Fixed a compile error that only Excel 2003 exhibits.

Fixed that the About screen does not show proper registration status

Fixed some problems related to Excel 2003.

Fixed some problems related to Excel 2003.

Fixed that the about button in Excel 2003 sometimes opened the About screen of another add-in.

Added a separate add-in file (.xla) for Excel 2003 and before.

Fixed an Excel 2007 issue

Improved returning to previous selection after closing the tool

Minor bugfix

Prevented unnecessary scrolling

Fixed bug with absolute cell references to multiple columns.

Fixed bug regarding files opened in protected mode

Minor bugfix

Fixed a compile error in Excel 2003

Fixed a bug for Excel 2013, prevents messages being covered by the application's screens

Fixed bug where RefTreeAnalyser removed the License registration information when unchecking the add-in

Fixed a bug for Excel 2013, preventad another message from being covered by the application's screens

Improved the error trace tool and the functioning of the stop button.

Important update: fixed some bugs in the multi-level precedents searching

Minor bugfix regarding Excel 2013 windows.

Improved tracing errors function

Improved reporting

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.

Fixed a bug pertaining to Excel 2003 and 2007

Visualize now also available for Excel 2003

Added an option to change the visualisation colors

Visualization: Improved placement of pictures of cells which are out of view

Fixed an issue with opening empty workbooks in 64 bit Excel 2013
Fixed issue with leaving an entry in the find dialog

Added new Object References option

Objects are now also analysed when tracing dependents and precedents.

Fixed a bug regarding Visualisation

Beta version

Made object search optional in find precedents/dependents

Improved progress bar for searching objects, prevented blank workbook when opening files from network shares

Improved reporting by adding hyperlinks; fixed some bugs

Added hotkey support for Objects and Check Formulas.

Added double-click functionality to the treeviews

Added ability to disable hotkeys

Added highlight formula blocks on "Check formulas" dialog, Improved performance of Check formulas.

Fixed bug regarding local range names

Small optimisations

Changed registration behaviour, registered copies no longer access the Internet to check for registration

Fixed a compile error

Added the "Formula Report" functionality

Fixed bug regarding startup screen not appearing in Excel 2013

Fixed a bug regarding registration of hotkeys

Fixed bug regarding startup screen not appearing in Excel 2013 (caused by an Office 2013 Update)

Fixed a window resizing bug

Improved calculation timer

Improved grouping in the Objects dialog, fixed screenupdating bug

Avoid trying to remove arrows when no arrows have been added

Added Alt key support for hotkeys

Fixed bug (treeview not responding)

Fixed a small bug

Fixed small issue with formula report and worksheet names that resemble dates

Fixed window handling for Excel 2013 and up

Fixed small bug regarding editing the formula in the dialog

Added unprotecting/protecting of workbook and worksheets, Fixed issue with removal of arrows

Fixed error message when quitting Excel without open workbooks.

Fixed asking for passwords when saving files

Fixed hang when using check formulas

Fixed a number of windowing problems related to Excel 2013 and 2016, fixed a bug in the Find Object references

Improved performance finding dependents, improved how Objects are listed

Improved error tracing, fixed bug regarding sheetnames with a pipe character

Fixed a bug regarding whole-column references

Fixed a bug in the sheet stats module

Fixed objects bug and added automatic update of precedents/dependents tracking

Fixed bug regarding setting errortracing hotkey

VBA code signed with new certificate

Added an off-sheet references report which visualises the inter-sheet formula links of your workbook

Fixed a number of bugs

Fixed a bug related to Excel 2013 and 2016; Improved Off-sheet references report to include checks for Tables and range names

Fixed a bug pertaining to unhiding worksheets

Fixed a bug causing crashes of Excel 2013 and 2016 when other certain add-ins are loaded

Added back double-click functionality to the treeview (same action as clicking Do ActiveCell

Improved scrolling within a table

Added a new function: Display formula as a mathematical equation

Fixed small bug in report formulas

Fixed bug regarding visualising merged cells

Added workaround for Excel bug affecting the "Display Equation" function in non-English Excel versions

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.

Fixed not selecting off-sheet references from the precedents/dependents trees (bug introduced in build 102)

Improved scrolling the selected cells into the viewable area of the screen

Fixed bug, Pivottables were not listed when pointing to a table name

Fixed issue with short-cut keys not responding immediately after openening Excel

Fixed bug where range names were no longer listed (introduced with build 105)

Added jump to pivotsource when you trace precedents when in a pivottable

Fixed repositioning of screen when re-activating dialog from Excel

Build 109 caused 64 bit versions of Excel to crash, this is fixed in this build.

Improved performance for Excel 2013 and 2016

Fixed progress bar problems (Excel 2013, 2016) by enabling user to use taskbar instead

Finally fixed an intermittent issue with the Visualize functionality on Excel 2016

Improved performance on analysing conditional formatting formulas

Fixed a small bug only occurring when you have a chartsheet selected

Enabled cyrrilic (and other non-western) character set for table names

Improved working of Tile option placing the dialog next to the Excel window, Improved reporting of formulas

Added an option to settings to enable or disable automatic unhiding of worksheets

Added Report Function Count, which reports a count of all Excel functions used in your model

Fixed a small bug

Improved performance of Dependents search

Fixed a bug with finding Dependents introduced with build 121

Updated "phone home" for registration

Included Array formulas in circular reference checks

Fixed runtime error due to third-party add-ins when checking if tool is installed

Adapted site addresses to use https

Added code to improve updating experience

Improved performance of formula checking and reporting significantly

Not published

Improved display of Object dependencies, improved tiling windows next to Excel.

Updated the tool so it works with the new Excel Data Types (Geography and Stock) and with the new Dynamic Array references

Not published

Improved finding, displaying and reporting of cell references used by Objects

Fixed an issue with finding references in chart SERIES formula

Fixed a visualization issue

Fixed a registration issue

Changed check for registration

Enabled selecting pivot table belonging to pivot chart

Couple of bugs fixed

Fixed a bug regarding handling of string literals in a formula

Improved the Check Formulas interface

VBA Project is now signed with a trusted code signing certificate

Fixed problem with not finding reference to total row of tables in the format Table1[[#Totals],[May-2019]]

Fixed problem with not finding reference due to an alt+enter character in the formula

Improved the layout of the Object references dialog

Fixed the wrong calculation setting (use 1 core only) of the add-in

You can now choose whether or not to display references in your formula more than once

Added a Reset button to the settings screen to remove registration details

Added PowerQuery M code to Object search. Fixed a bug regarding finding cell references in Objects

Improved performance and added an option to prevent the tool from offering to unprotect worksheets

Internal version

Fixed a bug relating to 64 bit Office. This is a recommended update if you are using 64 Office, which nowadays is the default version installed with a Microsoft 365 license

Added two new options: 1. Generate a Table of Contents and 2. Added a feedback button which takes you to a small survey so you can tell me what you like and what you do not like.

Small fix for Excel 64 bit.

Fixed bug in Search Objects feature: chart titles with formulas are now properly listed with their charts.

RefTreeAnalyser now recognizes external references in charts and no longer ignores them.

The display of objects has been improved.

Small bugfix to ensure backward compatibility with Excel 2013 and older.

Workaround for rare error regarding SAP add-in.

Bugfix for 64 bit Office.

Ensured obscure reference containing both a table total row and a cell outside the table works.

Added Form and ActiveX controls to the table of content option

Added Tables to the table of content option

Two updates: 1. The link back to the ToC is now independent of the name of the file. 2. If you press Precedents when a chart is selected, you get all references pertaining to that chart.

Fixed a bug which I introduced in build 166 :-(

Worked around a bug which Microsoft introduced

Fixed an issue with the Analyze off-sheet references tool

Improved sorting of chart series nodes on Objects dialog