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.
Build number |
Changes |
1.0.14 |
- 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.
|
1.0.16 |
- Hotkeys to start the tool
- Improved reporting
|
1.0.17 |
- Fixed a minor issue regarding double operators such as >=
|
1.0.18 |
- Fixed a small screen resizing problem
|
1.0.21 |
- RefTreeAnalyser now handles structured references to Excel
2007-2013 tables
|
1.0.23 |
- Prevent error message when workbook has protected worksheets
|
1.0.25 |
- Show message if no precedents/dependents have been found
|
1.0.26 |
- 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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
2.0, 058 |
- Changed registration behaviour, registered copies no
longer access the Internet to check for registration
|
2.0, 059 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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
|
Comments
Showing last 8 comments of 12 in total (Show All Comments):Comment by: Dave Hockin (11/7/2013 6:35:49 PM)
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 (11/7/2013 7:55:15 PM)
Thanks. That was one of the reasons for publishing build 42 indeed.
Comment by: VJ (9/26/2014 2:51:25 AM)
Comment by: Jan Karel Pieterse (9/26/2014 11:48:10 AM)
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 (4/17/2015 4:38:15 PM)
Jon
Comment by: Jan Karel Pieterse (4/17/2015 10:12:00 PM)
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 (3/1/2017 8:43:37 PM)
Comment by: Jan Karel Pieterse (3/2/2017 10:23:26 AM)
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: www.eileenslounge.com.