Email Multiple Worksheets w Links to Master Workbook

[nmoloney1968]

I have searched for about an hour in the threads looking for an answer to this, and have had no luck. We are a small group spread out all over the world trying to work on some excel sheets. The master workbook has links to other workbooks. Is there a way to force all of the links to only recognise the last folder name (i.e. /workbooks/data/data1.xls), rather than the absolute location (c:// blah/blah/blah.xls)? What we would like to do is have the child workbooks in a subfolder, the parent in a folder above that, and be able to zip up that folder with its subfolders, email them around, work on them, and keep on sending them round. I know this is an ugly way to do the job, so please don't flame me for that, but we don't have SharePoint capabilities, some of our team is in low-bandwidth areas (so no Google docs and so forth), etc. Some changes are always going to be made to the child workbooks, so just sending the master workbook and hitting Do Not Update doesn't really help. The master workbook is 8Mb, and the children are big also, so combining them is out of the question.

Does anyone have a method for doing this? If I need to be more clear in what I am after, please let me know!

Neil.

 

[retiredandsilly]

have you found an answer? i would also like to know, I'm in the same type of situation....no sharepoint; having many people that need to update information........

 

[nmoloney1968]

not yet, but it's only been an hour or so!