Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sharing workbooks via email
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I email Excel workbooks pages | New Users to Excel | |||
Range of Cells to create body of email | Excel Worksheet Functions | |||
Sharing Information Between Workbooks | Excel Worksheet Functions | |||
Email Macro with Outlook Express | Excel Discussion (Misc queries) | |||
Workbooks...I'll try this again... | Excel Discussion (Misc queries) |