Yes. When I open the xlsx file, the value in the second column is with a formula relationship with the first column, For example, when you click the 3rd row cell of the second column, that is, B3 , the cell B3 will not show its value but "=A3". It means that this cell has relationship with the first column. The solution is that we copy all its values in this xlsx file into another one to discard the formula, keep original values as text. Thanks so much!
... View more