xlCompare is Excel Workbook Comparison Tool, that helps you to find and merge differences between Excel worksheets, tables and Visual Basic Modules. xlCompare checks all parts of your workbook: constant cells, formulas, array formulas, cells formatting and VBA Forms and Modules.
Every highlighted cell with difference gets new text color, fill color and border.
No. xlCompare doesn't change original formatting. Difference Report you see is virtual. If you need to format changed cells with color - use Mark Changes command in the Difference Explorer.
After comparison is completed Difference Explorer appears below worksheet panels.
This requires a few clicks:
Yes sure! Use Print command in the Difference Explorer to export compared data with color formatting into PDF file ro to send it to printer.
Remember - color formatting is virtual. xlCompare doesn't change your workbook, whithout your command!
Use Save command above the worksheet. To save a copy of the file use Save As command. xlCompare saves book in the Excel format. XLS file is saved as XLS, XLSX as XLSX. Format of the original workbook is not changed.
It is highly important to perform saving operation safely to aviod data loss. The most common technique, widely used by all applications, is to create backup file before it is saved. When saving is successfully completed application deletes backup file.
xlCompare uses this way also. The only difference - backup file is not deleted after saving. So, you can get access to the previous verson of your workbook.
Open My Documents folder on your PC. There is a xlCompare subfolder. In this subfolder you can find the next one - Backup. This is the folder where all backup files are stored:
Documents | xlCompare | Backup
How to identify the workbook in this folder? This is easy. Backup file is create with it's original name. xlCompare adds data and time of the backup creation to the file name. So, if you've saved Loan Calculator.xlsx on the 05/12/2020 at 13:07:45, the backup file is - Loan Calculator.2020-05-12 13-07-45.xlsx.
If something goes wrong and you need to restore original file - you can find it in the backup folder.
You are protected from the data loss, when you are using xlCompare!
After your order is processed, our server IMMEDIATE sends you an email with license information. Use it to activate Excel Compare on your PC according to this step-by-step instruction.
xlCompare license allows you to transfer purchased software to another PC. You can't use the software on 2 computers at the same time. But when you buy or restore your PC you can move you xlCompare in a minute. The procedure is very simple. Look into the page below to get step-by-step instructions: