Subscribe
in a reader
RefTreeAnalyser versions
Current Version
The most recent version is is available for download here, which features the following additions/changes:
- Now also analyses objects on worksheets such as pivot tables, charts, form controls and etcetera.
- Fully 64 bit compliant
- Excel add-in, no setup or administrator rights needed to install
- Lots of added functionality
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
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
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
Comments
Showing last 8 comments of 16 in total (Show All Comments):Comment by: Jon Spain (17-4-2015 16:38:15)
Jon
Comment by: Jan Karel Pieterse (17-4-2015 22:12:00)
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)
Comment by: Jan Karel Pieterse (2-3-2017 10:23:26)
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?
Comment by: Wiens (26-9-2019 11:29:00)
2.0, 069
Bug gefixt (treeview reageert niet)
Comment by: Jan Karel Pieterse (26-9-2019 12:05:00)
Thanks! I've fixed that now.
Comment by: Wiens (27-9-2019 15:18:00)
Thanks for giving me the link to Stafford Quaid.
I have already contacted with him. I'll hope the Office issues will get fixed soon ;).
There is an issue on this page with the changelogs list of RefTreeAnalyser. The text aren't correctly orriented in the table and also the last changelog is added on the right side of the screen.
Comment by: Jan Karel Pieterse (27-9-2019 19:51:00)
So I see, thanks, fixed the layout.
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.