Sharing a workbook will be very helpful when several people are working on same excel file. Share workbook allows people to work in group. It allows editing the contents simultaneously.
For example, if the people in your work group handle several projects and need to know the status of each other's projects, the group can use a shared workbook to track the status of all the projects. All persons involved can then enter the information for their projects in the same workbook
Tip: To share a workbook, it should be saved in network location where other people can open it.
As the owner of shared workbook, you can manage it by removing users from the shared workbook and Accept or Reject changes made by others.
To share a workbook, execute following steps.
1. Go to Review tab-> Share Workbook
2. On the editing tab, click checkbox and click OK.
Now your workbook has been shared and other people will be able to edit the contents
Screen above shows who has opened this workbook now.
To highlight changes made by others, Go to Review tab->Track Changes
Select Highlight Changes
It will open dialog box for Highlight Changes. Click OK for default features.
Result: Excel highlights changes on screen.
As owner of Shard workbook, you can accept or reject changes done by others.
Go to Review tab-> Track Changes
Select Accept/Reject Changes.
Check the dialog box for options or Click OK for default feature.
It opens dialog box to Accept or Reject Changes. It displays the changes done by whom and what.
Click Accept to accept the changes or Reject to reject the changes.
Explore More…. It's Amazing!
1,684 total views, 1 views today