Share workbooks with Excel increase productivity

In Excel, we can set up workbook sharing to speed up data entry, and you can view changes at any time during work. When multiple people work together on a shared workbook, Excel automatically keeps the information constantly updated. In a shared workbook, individual users can enter data, insert rows and columns, change formulas, and so on, and even filter out the data they care about and keep their own windows.

Set up a shared workbook

We can give an example first: Assuming that there are four users of a B/N to work together to complete the input operation, four people in the 001, 002, 003, NO. 004 machine at the same time, the four machines have been connected with the number No. 000 computer through the network, The Student status information 2002.xls is stored on the hard disk of number No. 000 machine e:.

1, on the Tools menu, click the Share Workbook command, and then click the Edit tab, as shown in the figure.

2. Select the Allow multiple users to edit at the same time Allow workbook merge check box. You can set up automatic update interval, change conflict resolution between users, and personal view properties in the Advanced tab, and in general, the individual parameters in the Advanced tab can use the system defaults directly. then click OK.

3, when prompted, save the workbook.

4, on the File menu, click Save As, and then save the shared workbook on a network resource that other users can access (such as the number No. 000 machine, E:).

Second, use a shared workbook

1. View conflict Log

Conflict logs in a shared workbook, information that is saved for changes made during previous edits, including the author of each change, the time the change was made, and the data content changed.

There are two ways to view conflict logs: One is to stay on the worksheet with the mouse pointer over the cells that have been revised, highlighting detailed changes, and the second is to list each conflict on a separate conflict log worksheet by following these measures:

(1) On the Tools menu, select the Revision submenu, and then click Highlight Changes.

(2) Select the keep track of changes while editing, and share the workbook check box, which opens the workbook share and conflict log.

(3) Select the Highlight Changes on screen check box so that when you make the changes you want on the worksheet, Excel marks the cells that you modified, inserted, or deleted with the highlighted colors.

(4) Select the Show changes on new worksheet option to start the Conflict Log worksheet.

(5) Click the OK button, and when the pop-up dialog prompts you to save the workbook, click OK again to save the workbook.

2. Merging workbooks

When a merged user needs to obtain several backups of the shared workbook that they have changed, Excel requires that each backup of the shared workbook retain all conflict logs from the date the backup was created to the date of the consolidation, and that the backup cannot be merged if the number of days exceeds the specified retention time. The insurance option is to keep the conflict log long enough or to enter a maximum number of days, such as 1000 days.

The merge workbook works as follows:

(1) In another workbook file that you want to merge, open a backup of the shared workbook.

(2) Click the Merge Workbook command on the Tools menu.

(3) If prompted, please save the shared workbook.

(4) In the merge selected files into the current Workbook dialog box, click a backup of the shared workbook that contains the merged changes, and then click the OK button.

(5) Repeat steps (2) to step (4) until all the backups of the shared workbook are merged.

With the above setup, other users can edit and browse the agreed workbooks in their own computer, while the number No. 000 operator can see and manage all user-shared editing workbooks in their own windows. To facilitate actual operation, you should change the name of each user to their real names, click the tools → options → general → user name → Enter name → OK, so that you can correctly display all the user names and start times for the workbook you are using in the dialog box that pops up in the shared workbook (as shown in the previous illustration). In order to avoid several users to modify the contents of the same cell, you can estimate the number of records in the data, so that several users each assign different input parts. For example, let a from the work of the 1th entry, let B from the work Thin line No. 200 start ... However, you should be aware that you cannot edit and create hyperlinks in the shared workbook state, which can only be done in an unshared state.