A shared workbook can be edited by multiple users at the same time. This way you do not need to keep multiple copies of the same Excel spreadsheet if input from more than one user is required.
To edit a shared workbook, you must first locate and open it from its network location. Then click the Microsoft Office button and click Excel Options. In the Popular category, enter your user name in the User Name field. This information is used to identify your work within the shared workbook. Click OK.
Enter in the necessary data. Once you are complete, click the Save button on the toolbar. Your changes will be saved to the workbook and other users will be able to view them.