How to share a workbook in Excel 2007

You can share a workbook in excel 2007 to allow  multiple user  can edit a same time . Every user can view and saved who have access shared workbook .

Follow these steps to share workbook in excel 2007

1. Open Microsoft Excel workbook  which you want to share .
2. Click on Review Tab , then Click on Share Workbook .

3. Click on Editing Tab , then click on Allow changes by more then one user at the same time . This also allows workbook merging Check box .

4. Click on Advance Tab , Select option which you want to change. an click OK

5. Type the Name of the workbook what do you want , then select  a network location from where all user can access shared workbook , then click on Save .