4efTreeAnalyser versions

Current Version

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

RefTreeAnalyser does not error out when started whilst editing a cell

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.