I have linked crew data from access97 to one sheet1 excel97.

I link this work sheet cells to sheet 2 in the same work book to get the
crew names.

All is fine but when I refresh the data after changing the information in
access I get in sheet2 errors with #ref in the formula. I have to enter the
linking cells again and copy to all the cells.

Can you pls tell me,
1. why I am not able to automatically update on opening excell work sheet
tho I have modified in the data range properties to automatically update on
opening the excel sheet?

2. how to avoid this #ref error coming in the formulas of sheet2 on
refreshing the sheet1.

3. Pls note I programmed on comp-A, but use the program on networked comp-B.