Document sharing

Working together of multiple users on one document is a very common situation. The document can be found on a network, SharePoint Server or Cloud, and when working together, it is important to determine who is going to access the document, what changes he will make, and if more users are browsing content, which change should be accepted. In the following text, we will deal with the basic terms of exclusion and common work.

To enable the document to be delivered, it should first exist at the desired location. This may be a new document or some that we have done before, and we want to put it. It is important to note that when we share a document, all Excel features will not be supported. The reason is that the document is for more than one user, so we will not: add new sheets, delete sheets, merge or separate cells, create images, insert charts, etc.

Sharing a document is done by going to the ribbon Review, so we choose the Share Workbook option. After the selection, the dialog window opens with two tabs: Editing and Advanced. In the first tab, you need to mark the option to allow multiple users to change the file (Allow changes by more than one user at the same time). In the list below this option is a list of users currently working on the file. By tagging the user, we can remove one of these users by clicking on the Remove User button. However, we can not prevent the user from reopening the file. The Advanced tab contains advanced document rendering settings. In it first adjust how long we want the program to remember the changes in the file, how the change is updated, and if multiple users made a change that “changes” (whether Excel is asking the question when it comes to such a change or recognizing what is last saved). At the end, there are two optional fields in which we are adjusting whether we want to preserve our own print and filter settings.

Deleting a document is done after all users have completed their work on the document. In the Share Workbook window in the Editing tab, you first need to remove all users who have not checked out, and then uncheck the permission option to allow more users to change the file.

We can also share this document with the Protect and Share Workbook option. By launching this option, the dialog box opens whereby first we indicate whether we want to keep track of the changes in the document and then protect the document with the password. The purpose of the password is that anyone who does not know the password can not finalize the document and cease its work. Other features of this document are the same, and can also be set in the Advanced Share Workbook dialog box dialog.

The news provided by Excel 2016 is the option of sharing a document on the OneDrive repository. To be able to use it you need to be logged on to the OneDrive service. By clicking the Share button, in the upper right corner of the window, you can share the document and send a message to someone who needs to see it.