Clear linked columns in the Excel files

You have linked several columns on your worksheets in the xlCompare window.

How to clear the links?

  1. Right click on the worksheet window
  2. Select Manage Columns command in the context menu
Manage Columns command in the right click menu
This is the window where you can Hide, Ignore and Link all the columns on your worksheets.
  1. Use Select All button to select all items in list
  2. Apply the Link | Clear button to clear the links between columns
Clear the linked columns state
Now all columns on your worksheets don't have linked items.
Exactly in the same way you can clear link for the one specific column.
In this case you should omit the step with Select All button and select the column you need in the list.