totn Excel

MS Excel 2003: Share a spreadsheet between multiple users

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.

Microsoft Excel

When the Share Workbook window appears, click on the checkbox to allow changes by more than one user at the same time.

Microsoft Excel

Click on the Advanced tab. You can then customize the options. Click on the OK button.

Microsoft Excel

The following message should appear. Click on the OK button.

Microsoft Excel

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.

Microsoft Excel