EXCEL 2010 collaborate with a shared workbook

The use of workbook sharing to collaborate to complete a work is very convenient, such as a large number of data needs to be entered, take my town low-income input program (this program is based on the development of Excel) for example, the traditional stand-alone information management software system in the multiple user input is very troublesome, The approximate steps are: input → export → merge → summary, and excel in the work of thin sharing is convenient, fast, you can use the same workbook data entry, in the preservation of the same time can also see who is operating, as shown:

However, there are many features that are not supported in a shared state, as follows:

In addition, VBA is not supported for operation, we can see that in the state of shared workbooks there are a lot of can not use, can not play the greatest power of Excel, but we look carefully, in fact, in the data entry process to support the available function is enough to use, the following detailed steps to show the details of the display to everyone.

First, to ensure that you are in the LAN intranet normal, in your letter to create a new folder, such as we set up in F a "Heisha" folder, the New Right key → Properties Select the folder, share this file in the share, as shown:

In network sharing and security, two "√" to select, otherwise other users can not save. When determined, the folder icon becomes shared

Second, we will set our entry program as a shared mode and put in the "Heisha" This shared folder:

1. Open we need to share the work of thin, here we use the Urban minimum access procedures for example (hereinafter referred to as the program), in the Review tab in the group, a stand-alone shared workbook. As shown in figure:

When you open it, we'll see the tab for the shared workbook, as shown in figure:

Triple Recommendation: Click for free Download the latest version of WPS Office software "to see more computer tutorials

Note that you must check to allow multiple users to edit at the same time ... The option to be sure after Excel will prompt you to save, if you share a workbook that contains VBA, he will also remind you that VBA and macros cannot be edited under sharing, and finally we can see that the name of this program is followed by a shared typeface,

2012-2-24 14:51:17 upload Download attachment (5.08 KB) Now that this workbook is a shared state, the most we put this into a shared workbook program into the "Heisha" this shared folder. As shown in figure:

Well, the input of the preliminary work we have done well, then how can we let others also into the use of this program? First of all to know the computer in the network IP address or computer name is what, about these two issues do not say too much. For example, the name of this machine is "SUN" >

Well, the input of the preliminary work we have done well, then how can we let others also into the use of this program? First of all to know the computer in the network IP address or computer name is what, about these two issues do not say too much. For example, the name of this machine is "SUN" >

Well, the input of the preliminary work we have done well, then how can we let others also into the use of this program? First of all to know the computer in the network IP address or computer name is what, about these two issues do not say too much. For example, the name of this machine is "SUN" >

Well, the input of the preliminary work we have done well, then how can we let others also into the use of this program? First of all to know the computer in the network IP address or computer name is what, about these two issues do not say too much. For example, the name of this machine is "SUN", then we enter the Sunheisha in the address bar of the folder can access the computer through the LAN, and can be edited to save as shown:

2. Here is a demonstration of LAN sharing collaboration:

First look at the picture:

As you can see from the picture above, in the local area network, other users will change this program to save, I save, you can see other users modify the information, it should be noted that, if you do not save is not see the other party input or modify the information, of course, if you modify and save, Other users can also see the data you have modified after they have been saved.

3. Accept or reject the amendment. What is an acceptance or rejection of an amendment? The above figure we see, a user modified seven Heisha, I am this set workbook to share the person, this program in my machine, here I, equivalent to the host, and a user equivalent to access, assist my role, But do I agree to the amendment (Amendment) of the seven Heisha that a user has modified? or is that the seven Heisha who revised it? See the pictorial words:

Time: Choose today's date or choose none;

Revising person: You can choose a user who has modified this program, if you don't know, select everyone or everyone except me;

Location: You need to review the scope of the revisions, in this case, seven Heisha is our location.

When we're sure, we start accepting or rejecting, and continue to look at the picture:

So we know who modified the data, found that the data error can also choose to refuse to return the original text, very good.

4. Highlight Revisions. This function is needless to say, this function is after a user changes and save the data, we save the data, we can see something similar to the annotation, look at the picture:

See it! This is called the highlight revision.

5. Share advanced options in a workbook. Look at the picture:

Revision: This is the number of days to save the change history, or you can choose not to save it.

Update: The default is to update the data of other users at the time of saving, or you can set the automatic interval.

Conflicting changes between users: I have never encountered a conflict problem, as long as the division of Labor will not encounter this problem, so do not explain here.

Include in personal view: Check out the print settings and filter settings will not be visible to other users.

Third, how to cancel the sharing:

If you have all the above, the cancellation of sharing is very simple, review → changes → shared workbook → edit → will allow multiple users to edit the tick cancellation, after the confirmation will appear, such as figure.

The last option is to save the workbook at the same time.

OK, this is my grasp of the way to share the workbook, do not know if there are typos, there is no wrong place, there are questions or comments to tell me, like to share to everyone or reprinted into their own space, detailed reading, very simple.