Sharing Made Easy - Excel

Its extremely easy to create a workbook and place it on a network location where several people can edit the contents simultaneously. For example, if the people in your work group each handle several projects and need to know the status of each other's projects, the group can use a shared workbook to track the status of the projects. All persons involved can then enter the information for their projects in the same workbook. As the owner of the shared workbook, you can manage it by removing users from the shared workbook and resolving conflicting changes. When all changes have been incorporated, you can stop sharing the workbook.

Share A Workbook
Not all features are supported in a shared workbook. If you want to include any of the following features, you should add them before you save the workbook as a shared workbook: merged conditional formats
data validation, charts, pictures, objects including drawing objects, hyperlinks scenarios, outlines subtotals, data tables PivotTable reports workbook and worksheet protection, and macros. You cannot make changes to these features after you share the workbook.

Edit a shared workbook
After you open a shared workbook, you can enter and change data as you do in a regular workbook

Remove a user from a shared workbook
Before you stop sharing the workbook, make sure that all other users have completed their work. Any unsaved changes will be lost. Because the change history will also be deleted, you may want to start by printing the History worksheet or by copying it to another workbook.