The Protect and Share Workbook option only prevents turning off change tracking in a shared workbook, but does not prevent other users from editing or deleting the workbook's contents.
If you want to prevent people from changing important information in your Excel document, you will need to lock some areas before sharing it "before" is an important word here since the worksheet protection cannot be applied to an Excel shared workbook. For the detailed step-by-step instructions, please see:.
When deciding to share your Excel file, please be aware that it may cause some troubles to your users because not all features are fully supported in shared workbooks. Here are some of the limitations:. In fact, you will be able to use the existing features, but you won't be able to add or change them. So, if you'd like to benefit from any of the above options, be sure to apply them before sharing your Excel file.
The complete list of features unsupported in shared workbooks can be found on Microsoft's web-site. Now, you can input and edit data as usual, keeping in mind the following limitations of shared workbooks. When two or more users are editing the same workbook simultaneously, some edits can affect the same cell s. In such situations, Excel keeps the changes of the user who saves the workbook first.
When another user tries to save the workbook, Excel displays the Resolve Conflicts dialog box with the details about each conflicting change:. To have the most recent changes automatically override any previous changes made by you or by other users , without displaying the Resolve Conflicts dialog box, do the following:.
To view all the changes that have been made to the shared workbook, use the Track Changes feature on the Review tab, in the Changes group. It will show you when a particular change was made, who made it, and what data was changed. For more information, please see:. In some situations, it can be more convenient to save several copies of a shared workbook, and then merge changes made by different users.
Here's how:. The changes by different users are merged into a single workbook. Now you can highlight the changes , so you can view all the edits at a glance. Sharing an Excel file for multiple users can result in many conflicting changes. To avoid this, you may want to disconnect certain people from the shared workbook. If the selected user is currently editing the shared workbook, Microsoft Excel will warn you that any unsaved changes of that user will be lost.
You click OK to continue or Cancel to abort the operation and allow the user to save their work. If it is you that have been disconnected, you can preserve your work by saving the shared workbook with a different name, then reopen the original shared workbook and merge your changes from the copy you've saved. In the Custom Views dialog box, select the views you want to remove, and click Delete.
For sharing an Excel workbook with other users, we need to save this to a local network location where others can access it and make changes. We also can keep track of those changes and can accept or reject those changes as per the requirement. Below are the steps of sharing an excel workbook in excel —. We can accept or reject the changes done by other users if those changes are not according to us. For this, follow the below steps:. Excel shared workbook file feature has some limitations. Some of the limitations are:.
This has been a step by step guide to Share Excel Workbook File. You may learn more about excel from the following articles —. Your email address will not be published. Save my name, email, and website in this browser for the next time I comment.
Allow editing is automatically checked. Uncheck this if you only want to give permission to view the file, not edit it. Colored cells show you exactly each person is working in the workbook. Click a color to see who's editing that cell. Add, edit, delete, resolve, and show comments. A little purple flag appears in the top-right corner when a cell has a comment - point to the flag to reveal the comment.
Resolve - select the comment, then click the three dots in the top-right corner, and then click Resolve thread. The conversation will not be saved when you close the file. To keep a record of your chats, use Microsoft Teams. Table of contents. Excel for the web Quick Start.
Next: Welcome to Excel. Table of contents Excel for the web Quick Start. Excel training. Excel for the web More Share your workbook Select Share. Set permissions.
0コメント