MS Excel: Share a spreadsheet between multiple users in Excel 2003/XP/2000/97
Question: In Microsoft Excel 2003/XP/2000/97, how can I have one spreadsheet shared by many users? We want to all be in the same document at the same time saving changes.
Answer: To share an Excel spreadsheet, select Share Workbook under the Tools menu.
When the Share Workbook window appears, click on the checkbox to allow changes by more than one user at the same time.
Click on the Advanced tab. You can then customize the options. Click on the OK button.
The following message should appear. Click on the OK button.
Now when you return to the spreadsheet, you should see [Shared] at the end of the file name. This indicates that the Excel file is set up as a shared workbook.