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 Compare

Current Version: 10.0.0

Build Date: 7/28/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 xlCompare

Standard
Personal Use
$59.99 $48.99
  • Compare and Merge Sheets
  • Compare and Merge VB Projects
  •  
  •  
  •  
  •  
  •  
  •  
  • Free Updates
  • 1 User
Order Now
Professional
Business Use
$109.99 $89.99
  • Compare and Merge Sheets
  • Compare and Merge VB Projects
  • Command Line Mode
  • SVN\GIT Integration
  • Bulk Merge Commands
  • VBA Automation
  • Trace and Debug Calculations
  • License Never Expires
  • Free Updates
  • 1 User
Order Now
Professional, 5
Business Use
439.99 $349.99
  • Compare and Merge Sheets
  • Compare and Merge VB Projects
  • Command Line Mode
  • SVN\GIT Integration
  • Bulk Merge Commands
  • VBA Automation
  • Trace and Debug Calculations
  • License Never Expires
  • Free Updates
  • 5 Users
Order Now
* -20% SUMMER DISCOUNT is valid until September 1
* Standard license is for personal use only. You can't use it for your business
* All pricing packages include FREE Technical Support and new features with hotfixes by request.

Questions & Answers


Which payment methods are supported?
Orders are processed by our e-commerce partner, MyCommerce (Share*It) (part of the Digital River), through a secure SSL connection. It supports a rich set of payment methods: All major Credit Cards, PayPal, Bank/Wire Transfer, ...
Is this a one-time payment?
Yes, there will be no future payments. xlCompare is sold as a Permanent License. It's not like a regular subscription. You pay once and receive a lifetime license.
Do you have volume discounts?
Yes. If you are ordering 3 and more licenses, please contact us for a Coupon Code. We'll provide you a discount.
Do you collect my Credit Card information?
No. Spreadsheet Tools and Share-It does not collect your Credit Card data.
Should I order a license for my new PC?
No. If you've got new PC - you can transfer your license to this new computer. You can do it yourself on your account in the Customer Area, or you can send us an e-mail, and we'll do it for you.
How many activations do I have?
One xlCompare license allows you to use the software on one PC. If you plan to use xlCompare on more then 1 computer - you will need a license for the every PC.
Is technical support included?
Yes. Free updates and unlimited technical support is included with your license. If you have any questions - contact us to get a prompt response.
Do you work with resellers?
Yes. Please contact us to receive additional information.

Need Our Help?

If you have any questions regarding xlCompare, please contact us and we will give you a prompt response.

Spreadsheet Tools on Youtube

We've started publishing videos on the Youtube service, to show how to use xlCompare to compare Excel files for differences.

Ask, your questions directly in the comments, to share common questions with other users.

Please, visit out channel to get additional information about the product.