Most Valuable Professional


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

Home > English site > Products > RefTreeAnalyser > Version information
Deze pagina in het Nederlands

4efTreeAnalyser versions

Current Version

The most recent version is Build 1.0.26, which features the following additions/changes:

The RefTreeAnalyser works in Excel versions 2000, XP, 2003 and 2007.

Update Information

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

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.

 


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.

Please enter your name (required):

Your e-mail address (optional but if you want me to respond it helps!; will not be shown, nor be used to send you unsolicited information):

Your request or comment:

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