Debug calculated values in the Excel Workbook

xlCompare gives you a powerful tool for drill-down trace into calculations.

Compare Excel Worksheets

Debug calculated values in the Excel Workbook

When you are working on the complex spreadsheet models, you constantly have one of these questions:

  • How specific cell impacts to other cells?
  • How selected cell depends from input of your model?
  • Find indirect dependencies produced by reference functions (OFFSET, INDIRECT, INDEX, etc.).
  • Numbers in your spreadsheet model are wrong.
  • Complex formula returns unexpected value.
  • Why output cell contains error value?
  • Review all errors in workbook in single list.
  • Export list of dependencies to worksheet or text file for future use or printing.
  • and more ...

Evaluate Formula command will save you a lot of working hours!

xlCompare: Evaluate Formula

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:

xlCompare: Evaluate Formula Command

And in the Right Click context menu:

xlCompare: Evaluate Formula Command

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.

Download Excel File Compare

On the DOWNLOAD page you can select version of xlCompare for your PC and download the setup package.

DOWNLOAD NOW

Current Version: 10.3.0

Build Date: 12/1/2021


Version History

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.


Order Excel File Compare

Visit this page to get pricing information, license options and instructions on how to activate xlCompare on your computer.

ORDER NOW (-20%)