RefTreeAnalyser, Excel formula auditing made easy
Originally published: 03/12/2021 13:34
Publication number: ELQ-11090-1
View all versions & Certificate
certified

RefTreeAnalyser, Excel formula auditing made easy

The formula auditing options Excel offers have some severe limitations which RefTreeAnalyser resolves. It offers a much improved formula dependents navigation.

Description
RefTreeAnalyser: The Ultimate Excel Formula Auditing Tool For Microsoft® Excel®
Excel formula auditing taken to the next level!

Easily navigate the reference tree
The formula auditing capabilities of Excel are limited in that they display a bunch of arrows from the current cell to its 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 workbook name and sheet name is long (you're unable to see the cell addresses).
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.

Visual analysis
If you prefer a more visual way of detecting precedents, try the visualize option.

Features
Easy Auditing of formula dependents and precedents, including object dependencies (charts, pivot tables, form controls, Validation formulas, Conditional formatting formulas, etcetera)
Find circular references (yes, all of them!)
Trace errors
Find out which cells are used by all kinds of things in your file: pivot tables, charts, conditional formatting, data validation, forms and ActiveX controls and etcetera.
Generate a table of content containing not just your worksheets, but also your charts, pivot tables and (form) controls
Time your workbook calculation for each worksheet to find bottlenecks
Check columns for formula inconsistencies

This Best Practice includes
1 Excel add-in (in a zip file)

Jan Karel Pieterse offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Further information

This add-in only works on Windows versions of Excel

Does not work on Mac Excel


5.0 / 5 (2 votes)

please wait...