For office XP &
office 2003 :
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.
On the Advanced tab, select the options that you want to use for tracking and updating changes, and then click OK.
Do one of the following:
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.
Use a shared workbook for office 2007 :
On the Review tab, in the Changes group, click Share Workbook.
On the Editing tab, select the Allow changes by
more than one user at the same time. This also allows workbook merging check
box.
On the Advanced tab, select the options that you want to use for tracking and updating changes, and then click OK.
Do one of the following:
- If this is a new workbook, type a name in the File name box.
- If this is an existing workbook, click OK to save the
workbook, click Microsoft Office Button
, and
then click Save As.