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

Hi,

In the Tools (menu) | Options | Calculation (tab), uncheck the Update Remote
References and Save External Links checkboxes.

HTH

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)


"shirl" wrote in message
...

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

Assuming Excel 2002 or later (always helps if you tell us which):
- Would it not be sensible to email a copy in which the links are
broken and replaced by values (Edit / Links / Break Link)?
- You can change the startup behaviour using Edit / Links / Startup
Prompt

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup