Subscribe in a readerRefTreeAnalyser: The ultimate Auditing tool
Excel formula auditing taken to the next level!
Easy Auditing of formula dependents and precedents.
What is RefTreeAnalyser?
Ever had to work out the logic of other people's Excel files? Ever had to untie the spaghetti-knots of a large Excel workbook's formulas? Then you know what a nightmare this can be!
Now there is the RefTreeAnalyser, the must-have expansion of your Auditing toolbar and Formula tab of the Ribbon!
With this tool, finding out how a cell in a workbook derives its results and what other cells depend on the cell is a breeze. Read more about RefTreeAnalyser.
Supported Excel versions
RefTreeAnalyser is designed to work with Excel 2000, XP, 2003, 2007 and the 32 bit version of Office 2010. Note that it will NOT work on 64 bit Office 2010.
Purchase a license
The table below shows the current license costs for The RefTreeAnalyser:
| Number of licenses purchased | Price per license | Other currencies (approximate prices! Exchange rates may vary daily): |
| 1-5 | € 15.00
The button takes you to the Paypal site where
the payment process is handled. You can pay using your own Paypal
account, or use any credit card Paypal supports. Please note
that when you have arrived at the final Paypal payment page,
you have to click the link to return to this site. That will
trigger this site to send you the registration code. |
USA:$ 20 UK: £ 14 Canada: CAD 24 Australia: AUD 30 |
| 6 and up | Contact me |
Note: Prices are excluding local taxes. According to EU rules, client
will be responsible for paying any local taxes due.
For Dutch customers: BTW is included.
Please use the buy now button above for purchasing licenses or contact me for more information.
Money back guarantee
If you are in any way dissatisfied with RefTreeAnalyser, contact me within 30 days after your purchase and I'll issue a refund.
Download
Two versions are available for download:
- Demo version
- Licensed version
The demo version is fully functional, but has some restrictions:
- It shows a nag screen every time you launch the tool to analyse a cell
- Reporting is disabled
- The tool is limited to 1 level.
Download either version below.
Demo version
Demo version of RefTreeAnalyser V1.0 (Build 1.0.28, Updated January 26, 2012, downloaded: 3946 times)
Licensed version (requires a license key)
Licensed version of RefTreeAnalyser V1.0 (Build 1.0.28, Updated January 26, 2012, downloaded: 2638 times)
More information
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
Jan Karel Pieterse | info@jkp-ads.com
Copyright 2012| All Rights Reserved.
Comments
Showing last 8 comments of 26 in total (Show All Comments):Comment by: CHANDRU (5/3/2011 5:25:08 PM)Hi, I want to know how to nest different conditions in single cell. Eg., Row A1=X, Row B1=Y, Row C1=Z the row D1 = Autopopulated. If Rows A1, B1 and C1 are dropdown lists, how to nest and autopopulate in row D1 for possiblities in rows A1, B1 & C1... currently, all conditions are in different rows with formula =IF(AND(A1="A",B1="R",C1="T"), "Template Name","Error")
I would like to know if your tool can help me out on this function.
Regards,
Chandru
Comment by: Jan Karel Pieterse (5/4/2011 12:00:28 AM)Hi CHANDRU,
My tool is built to help you analyse from where a cell derives its results and which cells depend on the current cell. It does not help you create a function.
From your message I suspect you are asking how to create a cell formula that achieves a certain goal, but I am not sure I understand what the formula has to do exactly.
Comment by: Fabio (10/28/2011 11:36:12 AM)Hi, When do you think the 64 bit version would be available?
I just installed Office 2010 and I am desperate!!
Thanks, Fabio
Comment by: Jan Karel Pieterse (10/31/2011 1:09:13 AM)Hi Fabio,
Not any time soon I'm afraid.
Why have you installed 64 bit Office if I may ask?
Unless you are working with huge (and I mean huge) Excel files, there is not much benefit in using 64 bit Office.
Comment by: Bernard Lebelle (11/4/2011 2:33:11 AM)Does it work on Macintosh ?
Comment by: Jan Karel Pieterse (11/4/2011 5:05:53 AM)Hi Bernard,
Unfortunately not!
Comment by: yves labidoire (1/31/2012 12:13:10 AM)Hi,
Here is what i need and I think your tool could help but not 100 sure.
from one cell i need to know the entire fully exhaustive dependency tree. why it seems is what this tool does. But then i would like to recalculate the entire tree in excel. for this i need acess in text flie to all the data so that i can ask excel to recalculate all cells.
thx
Yves
Comment by: Jan Karel Pieterse (1/31/2012 6:06:47 AM)Hi Yves,
The tool gives you the precedents/dependents of the active cell in a number of levels you can select.
The max number of levels is set to 5 however, as otherwise you may end up waiting forever for the tool to finish. Also, the dependency tree becomes very difficult to understand with so many levels.
I'm not sure I understand why you need the text file?
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.