How to Edit Excel File with Multiple Users

How to Edit Excel File with Multiple Users

In this post we will learn How to Edit Excel File with Multiple Users.For this we have to save the Excel file on shared location(network drive) where several people can edit the contents simultaneously.As the owner of the shared workbook, you can manage it by removing users from the shared workbook and resolving conflicting changes.When all changes have been incorporated, you can stop sharing the workbook.

To Share the workbook:

1. Open the workbook which you want to share to edit with multiple users.

2. Click on Review tab, then click on Share Workbook.

How to Edit Excel File with Multiple Users

3. On the Editing tab, select the Allow changes by more than one user at the same time. This also allows workbook merging check box.

Use a shared workbook to collaborate - Excel

4. On the Advanced tab, select the options that you want to use for tracking and updating changes, and then click OK.

Features that are not supported in a shared workbook:

IN A SHARED WORKBOOK, YOU CANNOT BUT YOU MAY BE ABLE TO DO THE FOLLOWING
Create an Excel table None
Insert or delete blocks of cells You can insert entire rows and columns.
Delete worksheets None
Merge cells or split merged cells None
Add or change conditional formats Existing conditional formats continue to appear as cell values change, but you can’t change these formats or redefine the conditions.
Add or change data validation Cells continue to be validated when you type new values, but you can’t change existing data validation settings.
Create or change charts or PivotChart reports You can view existing charts and reports.
Insert or change pictures or other objects You can view existing pictures and objects.
Insert or change hyperlinks Existing hyperlinks continue to work.
Use drawing tools You can view existing drawings and graphics.
Assign, change, or remove passwords Existing passwords remain in effect.
Protect or unprotect worksheets or the workbook Existing protection remains in effect.