sharing and emailing a spreadsheet

[karen in Clovis]

I am a "rookie" excel user, but I have tried Excel help and it doesn't seem to be aswering my questions.

I need to send a "shared" spreadsheet to several team members (outside of a work network) through regular email, have them update some items and email it back to me. What would you suggest as the easiest way to do this? And how do I merge and update once I receive it back? Thanks for the help!

 

[DominicB]

Good morning karen in Clovis

Excel doesn't provide a built in way to e-mail files any more, but there are third party add-ins avalable to do so. You don't say which e-mail client you are using, but this add-in can be used with Outlook (/Express) :

http://www.rondebruin.nl/mail/add-in.htm

How you update the workbook depends on many variables. Do your colleagues update cells in the same sheet, each update a different sheet, same cells same sheet every time etc...? You need to provide more information on this, however in the first instance you could probably record a macro (Tools > Macro > Record new macro) to make the task a little easier.

HTH

DominicB