JKP Application Development Services.
Microsoft Office Application Development
|
|
| • • |
|
Microsoft Office Application Development
|
|
|
RefTreeAnalyser For Microsoft® Excel®Excel formula auditing taken to the next level! Why 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! 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. Current VersionThe most recent version is Build 1.0.16, which features the following additions/changes:
Contents:Why RefTreeAnalyser BenefitsEasily navigate the reference treeThe formula auditing capabilities of Excel are limited in that they display a bunch of arrows from the current cell to it's dependents and/or precedents. Navigating these arrows is relatively hard to do, especially if there are more than just one off-sheet reference and the combination of workbookname and sheetname is long (you're unable to see the cell addresses):
The RefTreeAnalyser greatly eases the navigation of dependents and precedents. You simply click on a found reference in a simple tree-like structured view and the accompanying cell or range of cells is selected. Quickly see what cells are referred toAlthough Excel does enable you to see what cells precede your cell and/or what cells use the current cell, getting an overview of them is quite hard. See the example below...
The RefTreeAnalyser greatly simplifies this as well: you get one tree-like overview of all cells that depend on the active cell and all cells that precede the current cell (and both may go up to 5 levels deep down/up the dependency tree!). The screenshot below shows what the same analysis looks like with RefTreeAnalyser:
Locate all circular referencesExcel does detect if a workbook contains circular references, but only enables you to navigate one. The RefTreeAnalyser detects all your circular references and shows them to you in one -easy to navigate- treeview. Generate a report quicklyExcel's formula auditing tools do not have any reporting options. The RefTreeAnalyser comes with a Report option which writes the current analysis to a new worksheet in your workbook. The report may look like this:
Screenshots
Below is a screenshot of the RefTreeAnalyser, showing both dependents and
precedents of a cell. Note that it shows the value in each cell next to its address and also highlights references which evaluate to an error in red automatically. And here is a screenshot of the tool after detecting circular references:
RefTreeAnalyser integrates nicely with Excel 2007:
Excel versionsThe RefTreeAnalyser works in Excel versions 2000, XP, 2003 and 2007. Update Information
DownloadsTwo versions are available for download:
The demo version is fully functional, but has some restrictions:
Download either version below. Demo versionDemo version of RefTreeAnalyser V1.0 (Build 1.0.16, Updated Mar 11, 2008, 758k, downloaded: 501 times) Licensed version (requires a license key)Licensed version of RefTreeAnalyser V1.0 (Build 1.0.16, Updated Mar 11, 2008, 763k, downloaded: 285 times) PricingThe table below shows the current license costs for The RefTreeAnalyser:
Note: Prices are excluding local taxes. According to EU
rules, client will be responsible for paying any local taxes due. Please use the buy now button above for purchasing licenses or contact me for more information. Operating InstructionsDownload the zip file by clicking the link below that says "RefTreeAnalyser". Open the ZIP and run SETUP.EXE. Start the tool from Excel's Tools menu:
or use the toolbar:
Or use the cell right click menu:
Please contact me for purchasing licenses or for more information. CommentsAll comments about this page: Comment by: Doug Glancy (12/17/2007 1:49:47 PM)Jan Karel, Today I had need for such a tool so I downloaded the demo. I clicked on a cell and chose "dependents". It started going through every row of another sheet which has about 1,300 rows. It was taking quite a while, so I hit stop and after about a minute it did. I wonder if Application.ScreenUpdating would speed things up? I then ran the uninstall from Add/Remove progams. It reported success, but the 2-icon toolbar was still in Excel. When I clicked on the left-hand button, I got the same message I'd get if I chose Tools>Formula Auditing>Trace Dependents. I deleted the toolbar in Tools>Customize and it's gone for good. I have 2 versions of XL on this computer 03 and 07. The toolbar is only present in 03 - I'm not sure if it was ever installed in 07. I thought you might like to know this. Doug Comment by: Jan Karel Pieterse (12/17/2007 10:24:07 PM)Hi Doug, Well, some food for thought there obviously. Screenupdating IS turned off as far as I know, but I'll double check. I also know about the toolbar problem and this is scheduled to be fixed in a later version. In 2007 you should look on the Formulas tab, no toolbar there. Comment by: Kristi (2/25/2008 3:26:25 PM)It would be helpful to see a screenshot of the report... Comment by: Kevin H. Stecyk (4/7/2008 6:24:23 AM)I really enjoy using your program. I've been using it steadily, and it certainly helps reduce the burden of understanding someone else's mess, I mean spreadsheet. Comment by: Jan Karel Pieterse (4/8/2008 12:53:21 AM)Hi Kevin, Thanks!! Much appreciated. Add a comment too!!!Please enter your comments about this tool below. Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. | |||||||||||||||||||||||||||||||||||||||||||||||||||
Use the contact page to issue
questions or comments about this website. |
Subscribe in a reader