Sharing Excel with multiple users - how to share your file

To make teamwork fast and easy, the easiest way is to share your Excel documents with multiple users. This way, the authorized participants can easily make the corrections as well as entries, and the editing process allows all team members to keep track of the changes.

This is how to share your Excel file

To avoid being thwarted by conflicts in your workflow in Excel, you need to get the preferences right to work together.

1. First you need to open the file you want to share and select the "Review" option. Now you will see the settings items and click "Share workbook" there.
2. Now you will see a dialog box where you can set the parameters to collaborate on the file. Check "Allow multiple users to edit at the same time" and confirm your selection with "Ok".
3. Now Excel will prompt you to save the file. Save the file in any location.
4. When you click on the document now, you will see that the file name has been extended by the addition "Shared".

Check the changes

To check which work steps your colleagues have made in Excel, click on "Check" and then on "Track changes". To see your colleagues' work even more clearly, select to highlight the changes. In addition, you can specify the time period as well as specific persons in the dialog box. After your confirmation, the desired cells will appear with a colored border. As soon as you move the mouse over the desired cell, you will see the work steps with timestamp.