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
Comments
All comments about this page:
Comment by: Alex (6/30/2010 3:06:24 AM)I bought the recent version one month ago - how can I assign a shortkut key to start the tool (using Excel 2007)? Thanks
Comment by: Jan Karel Pieterse (6/30/2010 3:42:39 AM)Hi Alex,
After installing the tool, the shortcut keys control+shift+[ and ] should launch the tool.
This is handled by a small Excel addin that should be checked to load at start of Excel. Check your list of add-ins (shortcut key is alt+t,i). There should be one called Reftreelauncher. If it is checked, uncheck it, close the dialog, open the dialog again and check that addin. Otherwise just check the addin.
I have been using the ReftreeAnalyser utility for quite long; congratulations, it's a great app! I just wanted to point out that the utility works only if the user has administrator's rights. The menu is not even visible in the ribbon in a user account with no administrators' rights. Can the utility be fully functional in Excel for such users, assuming the appication is deployed from a system administrator?
Comment by: Jan Karel Pieterse (5/16/2012 10:08:43 AM)Hi Apostolis,
That is odd, it should work with "normal" rights as far as I know.
Can you start it with the shortcut keys control+shift+[ and control+shift+] and control+shift+| ?
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.
Comments
All comments about this page:
Comment by: Alex (6/30/2010 3:06:24 AM)I bought the recent version one month ago - how can I assign a shortkut key to start the tool (using Excel 2007)? Thanks
Comment by: Jan Karel Pieterse (6/30/2010 3:42:39 AM)Hi Alex,
After installing the tool, the shortcut keys control+shift+[ and ] should launch the tool.
This is handled by a small Excel addin that should be checked to load at start of Excel. Check your list of add-ins (shortcut key is alt+t,i). There should be one called Reftreelauncher. If it is checked, uncheck it, close the dialog, open the dialog again and check that addin. Otherwise just check the addin.
Comment by: Apostolis (5/16/2012 9:15:33 AM)Hi Jan,
I have been using the ReftreeAnalyser utility for quite long; congratulations, it's a great app! I just wanted to point out that the utility works only if the user has administrator's rights. The menu is not even visible in the ribbon in a user account with no administrators' rights. Can the utility be fully functional in Excel for such users, assuming the appication is deployed from a system administrator?
Comment by: Jan Karel Pieterse (5/16/2012 10:08:43 AM)Hi Apostolis,
That is odd, it should work with "normal" rights as far as I know.
Can you start it with the shortcut keys control+shift+[ and control+shift+] and control+shift+| ?
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.