Excel lets you create a shared workbook and store it on a network location so other people can make changes to the contents at the same time.
Very rarely, is a file created, reviewed and edited by a single person. People work collaboratively to build files such as documents and spreadsheets. To facilitate collaboration when building spreadsheets, you can create a shared workbook. By doing so, other people can add information to the workbook instead of having to maintain multiple spreadsheets. Not only does this facilitate collaboration, it also eliminates the need to maintain multiple files, which can result in version control issues.
You can easily create a shared workbook in Excel 2007 using the steps outlined below:
- Create a new workbook and enter in the required data.
- 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.’ option and click OK.
- Save the workbook to a location on the network that all the required users have access to.
[awsbullet:Microsoft Office Home and Student 2007]