How to Edit Cells With Multiple Users in Excel 2007

1. Format the document prior to sharing it across a network. Once an Excel 2007 file is shared, many common formatting procedures are no longer available until the sharing is deactivated. These include conditional formatting, charts, pictures, links, outlines and PivotTables. It is best to prepare the file for mass data entry with the features everyone will need during editing.
2. Click on the 'Share Workbook' button. This will open up the features dialog for network sharing of the Excel 2007 document with multiple users. The button is found on the Review tab of the Excel 2007 toolbar, in the Changes group.
3. Save or copy the file to a shared network folder that all users can access.
4. Inform all users of the location of the shared Excel 2007 document. Each user will see changes by other users every time they press the 'Save' button. The overlapping changes in the document will occur seamlessly with the exception of multiple edits to the same data cell. In this case, saving the file will launch a conflict resolution window to choose between your changes and those input by another user.