How to Have Multiple Users Use One Sheet in Excel

Sharing in Excel 97/2000/XP/2003
1. Create or open the workbook you would like to share.
2. Under the Tools menu, select 'Share Workbook.'
3. The 'Share Workbook' window will appear. The 'Editing' tab shows all users who currently have the workbook open (you should see your name in the list). Click the box to allow other users to access the workbook simultaneously.
4. The 'Advanced' tab allows you to adjust the options for sharing, such as how long changes are tracked, how often they are updated and what happens when information conflicts. Select the options you wish to implement and click 'OK.'
5. A message box will appear confirming you would like to save the workbook. Click 'OK.' The word 'Shared' should now follow the file name at the top of the window.
Sharing in Excel Office 2007
6. Create or open the workbook you would like to share.
7. Under the 'Review' tab at the top of the page, click on the 'Share Workbook' icon in the 'Changes' group.
8. As with previous Excel versions, the 'Share Workbook' window will appear. The Editing tab shows all users who currently have the workbook open (you should see your name in the list). Click the box to allow other users to access the workbook simultaneously.
9. Click on the 'Advanced' tab to adjust the options. Select the options you would like to implement and click 'OK.'
10. If it is a new workbook, the program will prompt you to save it. Enter the file name you wish to use and click 'Save.' If the workbook has already been saved, a message box will appear confirming you would like to save the workbook. Click 'OK.' The word 'Shared' should now follow the file name at the top of the window.