We suggest you to review the topics below. Possible you'll find answer to your questions about xlCompare
We've created a F.A.Q
section on our website. It contains answers to the most common questions
we receive. In this section you'll also find a useful information for you. Go to the F.A.Q. topic
Tools | Recalculate menu command
xlCompare opens your workbook in the Manual Calculation Mode. Data is not recalculated after the every change in the cell.
Use should use this command to recalculate the workbook and see the result of your changes.