Often times a document or spreadsheet is not compiled by a single person but rather requires input for multiple people. In Excel, you can create a shared workbook and store it on the network so it can be edited by the necessary users. This way each person can add information to the same workbook instead of having to maintain multiple spreadsheets.

You can create a shared workbook using the steps outlined below:

1. Create a new workbook and add in the required data.

2. From the Tools menu, click Share Workbook.
3. On the Editing tab, select the Allow changes by more than one user at the same time option and Click OK.
4. Save the workbook to a location on the network that all the required users have access to.

[tags]excel,office,spreadsheet,diana huggins,shared workbook,allow changes[/tags]