When you are working on the complex spreadsheet models, you constantly have one of these questions:
It shows value of the every part of the formula expression. And you can expand it to trace precedent and dependent values.
Command is present on the Ribbon:
And in the Right Click context menu:
You may say, that there is Trace Precedents and Trace Dependents commands in Excel. It is possible to use them.
xlCompare shows actual dependencies in your model. It finds hidden dependents and precedents, produced by OFFSET, INDIRECT and other lookup functions. Which are not visible with another tracing tools and not publish in Excel.
Evaluate Formula command has simple and clear interface - it displays dependents and precedents in the tree-like recursive form. This way allows quick and native navigation by expanding levels of the tree.
Just try it once and you'll use it every time.
Current Version: 9.4.1
Build Date: 6/9/2021
During 10+ years our team has been working to provide you a robust and quality software. It boosts your productivity and saves you time and money. Just look into our list of changes on the page below to imagine amount of work done on the product.
If you have any questions regarding xlCompare, please contact us and we will give you a prompt response.