If you need input from several people, you can create a shared workbook (shared workbook: A workbook set up to allow multiple users on a network to view and make changes at the same time. Each user who saves the workbook sees the changes made by other users.) and place it on a network location where they can edit it simultaneously. For example, if the people in your workgroup each handle several projects and need to know each other's status, the group could use a shared workbook. All persons involved can then enter the information for their projects in one and the same workbook.
To create a shared workbook:
- From the Tools menu choose Share Workbook…
- Check the box to “Allow changes by more than one user at the same time” then click OK
- Save the workbook to a network drive accessible to those who need to edit the workbook.
