RefTreeAnalyser Operating instructions

Download the zip file by clicking the link that says "RefTreeAnalyser". Open the ZIP and run SETUP.EXE.

Start the tool from Excel's Tools menu:

Or from the formulas tab of the ribbon of Excel 2007:

or use the toolbar:

Or use the cell right click menu:

Comments

All comments about this page:

Comment by: Elliot Seligman (9/11/2009 7:23:18 AM)

RefTreeAnalyser --

What is your upgrade / update policy as new versions are released -- are they Free Forever? Minor Upgrades only?

Thanks
Elliot

Comment by: Jan Karel Pieterse (9/11/2009 7:55:02 AM)

Hi Elliot,

Updates are free until I decide to publish a major new release. I plan to have an upgrade version for a rebate then.

Comment by: Mike Budd (4/30/2010 5:10:10 AM)

Just trying out the demo version, which is a great tool!

One small problem, the analyser does not seem to fully deal with named formulae. (Situations where a formula has been typed into the refers to field of a named range). It does sensibly list all the usages of named functions in the same column so I can look at them myself, but it does not select just those that are related to the cell under analysis. Any way round this?

In addition, it gives numeric cell references in the references display, not the names of named ranges. Any way I can toggle the names?

Many thanks again

Mike

Comment by: Jan Karel Pieterse (4/30/2010 6:51:02 AM)

Hi Mike,

Could you perhaps send me your file (see email address at bottom of this page)?
If so, please include some information on which cell you are analysing and what you get and what you expect to get?

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.