Sharing Workbooks on a Network
If you use Excel on a computer connected to a network, you can share the spreadsheets that you create with other users who have network access. Workbook sharing is perfect for spreadsheets that require frequent or regular data updates, especially those whose data comes from several departments. For example, spreadsheets that track budgets or schedule projects that rely on input from many departments can benefit from workbook sharing.
This technique covers the different ways you can share a workbook so that different people can edit its contents at the same time. It also covers how to set the sharing options that control how Excel handles conflicting updates that users make to the same cells of a worksheet.