Excel Shared Worksheet Tips

The shared workbook feature lets users create and edit formulas, change formatting, and even add worksheets by using a shared workbook. Create several links between Microsoft Excel workbooks and the information in external workbooks or external files. The files that are linked to the workbook can be on this computer, on the local area network, or on the Internet. By using these methods to link to data rather than copying them, you can easily update the workbook when the external data is changed.

In Microsoft Excel 2000, it is easier to work together because each member of a workgroup can edit the workbook at the same time. Highlighting revisions, conflict logs, and annotations makes it easy to understand the work of other users.

14.1.1 Set up shared workbooks

1. Execute the Share Workbook command on the Tools menu, a dialog box appears, and then click the Edit tab, as shown in Figure 14-1.

2. Select the Allow multiple users to edit at the same time to allow workbook merging check box, and then click the Confirm button.

3. The Save As dialog box appears and then saves the shared workbook on a network hard disk that other users can access.

4. When finished, press the "Save" button and you can see the "share" flag on the title bar of the file.

Then, if another user on the web is using the file, the Share Workbook command on the Tools menu, a dialog box appears, and then click the Edit tab to see the user who is using it.

14.1.2 to undo the shared status of a workbook

If you no longer need someone else to make changes to the shared workbook, you can open and manipulate the workbook as a unique user. Once the workbook has been shared, it interrupts all other users ' contact with the shared workbook, closes the conflict log, clears the stored conflict log, and then no longer looks at the conflict log, or the shared workbook

1. Execute the Share Workbook command on the Tools menu, a dialog box appears, and then click the Edit tab, as shown in Figure 14-1.

2. Confirm that you are the only user in the Open Workbook user box, and that if there are other users, they will lose their unsaved work.

3. Clear the Allow multiple users to edit at the same time to allow workbooks to merge check box, and then click the Confirm button.

4. The message box appears as shown in Figure 14-2, click "Yes" button.

Note: to ensure that other users do not lose work progress, you should confirm that all other users have been notified before you undo the workbook share so that they can save and close the shared workbook in advance.

14.1.3 view changes in a workbook

To view information about revisions in a workbook, you can do the following:

1. Follow the change command on the Tools menu, perform the highlight Changes command, and appear in the dialog box as shown in Figure 14-3.

3. Set the desired options as needed, pressing the "OK" button to see the blue border of each cell that was modified. Then, when you point to these cells, a message box appears, as shown in Figure 14-4.

14.1.4 complete the changes in the workbook

1. Follow the "change" command on the Tools menu, and perform the Accept or reject Changes command, and the dialog box appears as shown in Figure 14-5.

3. Set the desired options as needed and press the "OK" button to see the dialog box shown in Figure 14-6. In this dialog box you can see the document's revision information, such as time, content, and user. There are also five buttons: Accept, Reject, accept all, reject all, and close.

In the dialog box, we can press the appropriate button as needed. For example, press the Accept button and the system automatically moves to the next modified cell. Select Accept all to confirm all changes. Press the Deny button and the system will fix the status before the worksheet is repaired. Press the Reject All button and the system will discard changes to the worksheet.