#26611 Working with multiple users on the Shared Excel sheet at the same time

#26611 Working with multiple users on the Shared Excel sheet at the same time

First, open the shared Excel file

Select REVIEW tab -> Share Workbook

Menu Bar

When you select Share workbook the first time the below trust center message will appear, select Ok.


Trust Center Message

On Excel menu click on File -> options -> Trust Center -> Trust Center Settings

Excel Options

Then select Privacy options and uncheck Remove personal information from file properties on save box.

Trust Center

Select Save and close

Finally, Select REVIEW tab once again -> Check Allow changes by more than one user at the same time. This also allows workbook merging. -> Ok.

Share Workbook

Now you can open and manipulate your Excel file from more than one client machine .