When you don't have opened workbooks in xlCompare, this form is a result of pressing the Merge button.
There are several ways, how to open workbooks in xlCompare.
That's all you need to do. xlCompare displays you merged workbooks.
Changes from the left sheet were moved to the right one.
xlCompare merges ALL changes from MINE workbook, into the BASE one. In other words: ALL changes made in the LEFT worksheet is copied into the RIGHT worksheet.
Changes made in the BASE file (right worksheet) are NOT copied into the MINE file (left worksheet).
You can switch workbooks if you want to apply changes to other file.
Use option Mark Changes When Merging to apply color formatting to every changed cell and unique row.
This procedure is the most common way - when all options are determined by xlCompare.
However, you can use full set of xlCompare comparison options to merge your Excel files.
In this case you SHOULD NOT press the Merge button.
Just drop your files into the xlCompare window, and make sure that MINE and BASE workbooks are selected correctly. Switch workbooks, if they are on the wrong locations.
On this step you can:
Now you need to select worksheets and VBA modules to be compared and merged/
After pressing Compare button on the dialog, described above, you get comparison results.
Now you see which cells will be merged from MINE workbook into the BASE one.
This will start merging operation.
All changed and unique cells will be moved from left workbook into the right one.
xlCompare is able to perform all types of merge operations you encounter on the daily basis. This tool allows to merge workbooks in single click and to select and preprocess data before merging.
In any case this operation is quite simple and requires only a few second.
Pick the version that's suitable for your Windows version. A free trial is available to help you with the decision-making.
Current Version: 10.0.0
Build Date: 7/28/2021
During 10+ years, our team has been working to provide for 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 the amount of work done on the product.
64-bit and 32-bit versions are supported
xlCompare is based on the Spreadsheet Core engine.
It doesn't require Microsoft Excel to be installed.
If you have any questions regarding xlCompare, please contact us and we will give you a prompt response.
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.