How to Share Modify Excel Documents

Sharing
1. Open your workbook.
2. Click 'Review,' then 'Share Workbook.'
3. Check the ' Allow changes by more than one user at the same time' and 'This also allows workbook merging' check boxes.
4. Click 'Advanced,' then change the settings for tracking changes. Click 'OK.'
5. Save the document in a network directory.
Modifying
6. Open the workbook on the network drive by double-clicking on the workbook.
7. Click the 'Office' button, then 'Excel Options.'
8. Click 'Popular,' then 'Personalize your copy of Office.' Enter your name in the user name section.
9. Edit the data as you normally edit a workbook.
10. Save the file.