Thread: link worksheets
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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!!!