Please, review topics below to find answer to your question

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.