link worksheets
 

i am working with a worksheet in the following way

column A through F have been linked with the corresponding columns in another workbook. columns G through J contain data that i have to fill in manually. For example A1 contains the name of a client (link) and G1 contains transportation means. the problem is, however, that i trace errors whenever i sort records (data). rows containing data in columns A through F remain correct, but the same rows contain errors in columns G through J contain errors. data in the same row get mixed up. Am i doing something wrong or is it impossible to work with a <<partially linked worksheet

please help me solve this problem!!!

link worksheets
 

If you have relative addresses in your formulas, you can run into this
problem.

--
Regards,
Tom Ogilvy

"angie" wrote in message
...
i am working with a worksheet in the following way:

column A through F have been linked with the corresponding columns in
another workbook. columns G through J contain data that i have to fill in
manually. For example A1 contains the name of a client (link) and G1
contains transportation means. the problem is, however, that i trace errors
whenever i sort records (data). rows containing data in columns A through F
remain correct, but the same rows contain errors in columns G through J
contain errors. data in the same row get mixed up. Am i doing something
wrong or is it impossible to work with a <<partially linked worksheet?

please help me solve this problem!!!