Linking Data in different workbooks and then sorting
 

Hi

I have column A of workbook B linking to data in workbook A; then column B of workbook B has independent data values. When I sort workbook A the data points move in workbook B; and then columns A and B in workbook B become out of sync.

Is there any solution to this problem?

Thanks!