C
CAPTGNVR
D/All
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.
brgds/captgnvr
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.
brgds/captgnvr