A colleague has a master workbook which is linked to several other
workbooks, each week the workbooks are emailed out to staff who are not
located on the same network or building. Each person inputs their data
which is then emailed back to my colleague.

The question is, that when the workbooks come back the links within the
formulas have all changed, can we prevent this happening? And can we
also prevent the box which asks if the links should be updated,
appearing?

Thanks
Shirley


--
shirl