If you are sure that your worksheets contain no deleted or inserted columns/rows, you can check the fields "Link 1 on 1 for columns/rows". This overrides the linking algorithms.
Proceed as follows to link the data 1 on 1:
1. |
Select the worksheet "couple" containing the desired data |
|
2. |
Select the button "Edit ranges and database options" (icon to the right) or double-click on the pair of worksheets, which must be edited. The option field appears |
|
3. |
The following checkboxes appear
|
|
4. |
Click on the desired checkboxes and start the comparison. |
|