Excel Create a shared document: step, Key points and implementation methods!

This article mainly introduces how to use Excel createCreate shared documentsThe steps, Key points and implementation methods. Firstly, the preparation work and basic operations were introduced, Then, the four aspects were explained in detail, Including file settings, sharing option, Permission settings and implementation methods. Afterwards, the entire text was summarized.

1, Preparation work and basic operations

in use Excel createCreate shared documentsbefore, We need to do some preparation work and basic operations. first, We need to determine what we want to share Excel file, And save it in an appropriate location. secondly, We need to open it Excel, And navigate to the file options. stay "Advanced Options" in, We need to activate "shared workbook " option. then, We need to set an access password, To ensure that only authorized personnel can access shared documents. after, Save and Close Excel file.

2, File Settings

Before creating a shared document, We need to make file settings. first, open Excel file, find "file" option, And select "information" .

stay "information" In the tab, We can see that "Protect workbook" option. click "Protect workbook" After the options, choice "Restricting Editing" option. In the pop-up dialog box, We can choose different permission levels, For example, only allowing specific users to make modifications, Only allow specific users to review, etc.

In file settings, We can also add or remove sharers. click "Add personnel" option, We can choose the contacts to share, And set their permission levels. For the shared personnel that have already been added, We can further modify its permissions or delete its sharing permissions.

3, sharing option

stay Excel in, We can customize shared documents through sharing options. click "share" tab , We can see that "shared workbook " Button. After clicking this button, A dialog box will pop up, We can set sharing options in it.

In the sharing options, We can choose the objects to share, For example, all users, Specific username or user sent via email. We can also set the permission level for sharing, For example, allowing shared personnel to make modifications, Review or Read Only.

In the sharing options, We can also set more advanced options. such as, We canShare filesAutomatic update frequency, Set up areas that collaborators can add or modify, And choose whether to allow collaborators to annotate and annotate through editing tools.

4, Implementation method

In achieving Excel During the process of sharing documents, We can choose different methods. One method is to use a shared serverFile sharing. under these circumstances, We need to Excel The file is saved on a shared server, And set sharing permissions on the shared server.

Another method is to use cloud storage servicesFile sharing. We can use methods such as OneDrive, Google Drive, Dropbox Waiting for cloud storage services to share Excel file. under these circumstances, We need to Excel The file is saved in a specific folder of the cloud storage service, And set sharing permissions.

No matter which method is used, We all need to ensure that the permission settings for sharing documents are correct, And carefully manage the access permissions of shared personnel. in addition, We can also regularly backup shared documents, To prevent accidental loss or damage.

Through the introduction of this article, We understand the use of Excel Steps to create a shared document, Key points and implementation methods. first, We need to prepare and perform basic operations. then, We need to make file settings, Including setting up workbook protection and adding shared personnel. next, We can customize the settings for sharing documents through the sharing option. after, We can choose different implementation methods, Such as shared servers or cloud storage services. By setting reasonable permissions and conducting regular backups, We can better manage shared documents.

About Us

　　China's leading enterprise collaboration and knowledge management platform 360Fangcloud, Store massive files, Online Editing, Multi format preview, Full text search, File comments, Security control and other functions, Assist enterprises in building a knowledge base, Improve internal and external collaboration efficiency. at present, 360FangcloudService has exceeded 56 Wanjia Enterprise Users, cover 20 Multiple industries, Among them is Zhejiang University, Country Garden, Changan Automobile, Geely Group, Jinko Energy, Large clients such as Jinyuan Group.