Excel training. Excel for the web More Share your workbook Select Share. Set permissions. Select Apply. Enter the names or email addresses of who to share with. Add a message optional. Select Send. Or, select Copy link to get a link to the file. Co-author a workbook After you share your file, you can work on it with others at the same time. For the best experience, work together in Excel for the web and see real-time changes.
Under Share , you'll see the names of who else is also editing the file. Chat while editing If another person is editing the file at the same time, you can chat with them.
Files that are not affected correctly show as being open until closed. This problem does not appear to affect word or any other application. Also affected files cannot e deleted - even after a re-boot. Problem is not limited to any one share or user. Have tried disabling Mcafee Anti virus enterprise on both server and client machines. Would really appreciate any help with this Thanks. Join our community to see this answer! Unlock 1 Answer and 5 Comments.
Andrew Hancock - VMware vExpert. The recent versions of Excel , and make it easy to share and collaborate on workbooks. By sharing an Excel file, you are giving other users access to the same document and allow them to make edits simultaneously, which saves you the trouble of keeping track of multiple versions.
This section shows how to share an Excel workbook for multiple users by saving it to a local network location where other people can access it and make edits. You can keep track of those changes and accept or reject them. For example, you may want to have changes updated automatically every n number of minutes all the other settings on the screenshot below are the default ones. If done correctly, the word [Shared] will appear to the right of the workbook's name as shown in the screenshot below:.
Now, you and your colleagues can work on the same Excel file at the same time. You are free to accept or reject their changes, and after the desired changes have been incorporated, you can stop sharing the workbook. Further on in this tutorial, you will find the details on how to do all this. If you'd like not only to share an Excel file, but also to ensure that no one turns off the change history or removes the workbook from shared use, proceed in this way:. Though entering a password is optional, you'd better do it.
Otherwise, there's little sense in using this option, because anyone would be able to remove the protection and thus stop the workbook sharing. Save the workbook. Clicking OK in the above dialog box will change the Protect and Share Workbook button on the ribbon to Unprotect Shared Workbook , and clicking this button will both remove the protection from the shared workbook and stop sharing it.
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:.
If you want several users to work in the same Excel workbook simultaneously, you can save the workbook as a shared workbook.
Users can then enter data, insert rows and columns, add and change formulas, and change formatting. It is not possible to open shared workbooks that are created in Microsoft Excel 95 in later versions of Excel and still maintain their shared status. To make changes to a shared workbook that was created in Microsoft Excel 97 or a later version of Excel, you must use Excel 97 or a later version of Excel.
Specifically, even if a shared workbook that was created in Excel 97 or a later version of Excel is saved as an Excel 95 workbook, the workbook cannot be shared.
0コメント