Multi users editing the same excel document

Works with Office 2003 & 2007.

==To view a workbook's share settings:

Go to: Tools / Options / General / Service Options / Share Workspace

==Add the user to the "Share Workbook"

On the Tools menu, click Share Workbook, and then click the Editing tab.

Select the Allow changes by more than one user at the same time check box, and then click OK.

When prompted, save the workbook.

On the File menu, click Save As, and then save the workbook on a network location accessible to the intended users. Use a shared network folder, not a Web server.

==Other Share Workbook settings

To see who else has the workbook open, click Share Workbook on the Tools menu, and then click the Editing tab.  If you want to get automatic updates of the other users' changes periodically, with or without saving, click Share Workbook on the Tools menu, click the Advanced tab, and under Update changes, click the options you want.

==To Edit a Shared Workbook

Go to the network location where the 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.) is stored, and open the workbook.

Set the user name to identify your work in the shared workbook: on the Tools menu, click Options, click the General tab, and then type your user name in the User name box.

Enter and edit data as usual. You won't be able to add or change the following: merged cells, conditional formats, data validation, charts, pictures, objects including drawing objects, hyperlinks, scenarios, outlines, subtotals, data tables (data table: A range of cells that shows the results of substituting different values in one or more formulas. There are two types of data tables: one-input tables and two-input tables.), PivotTable reports, workbook and worksheet protection, and macros.

Make any filter (filter: To display only the rows in a list that satisfy the conditions you specify. You use the AutoFilter command to display rows that match one or more specific values, calculated values, or conditions.) and print settings you want for your personal use. Each user's settings are saved individually by default.

If you want the filter or print settings made by the original author to be in effect whenever you open the workbook, click Share Workbook on the Tools menu, click the Advanced tab, and under Include in personal view, clear the Print settings or Filter settings check box.

To save your changes to the workbook and see the changes other users have saved since your last save, click Save .

If the Resolve Conflicts dialog box appears, resolve the conflicts.