Show All

Stop sharing a workbook

1. Have all other users save and close the shared workbook. If other users are editing, they will lose any unsaved work.
2. Unsharing the workbook deletes the change history. If you want to keep a copy of this information, print out the History worksheet or copy it to another workbook.

   How?

   1. On the Tools menu, point to Track Changes, and then click Highlight Changes.
   2. In the When box, click All.
   3. Clear the Who and Where check boxes.
   4. Select the List changes on a new sheet check box, and then click OK.
   5. Do one or more of the following:
      • To print the History worksheet, click Print .
      • To copy the history to another workbook, select the cells you want to copy, click Copy , switch to another workbook, click where you want the copy to go, and click Paste .

      Note  You may also want to save or print the current version of the workbook, because this history might not apply to later versions. For example, cell locations, including row numbers, in the copied history may no longer be current.

3. On the Tools menu, click Share Workbook, and then click the Editing tab.
4. Make sure that you are the only person listed in the Who has this workbook open now box.
5. Clear the Allow changes by more than one user at the same time check box.

   If this check box is not available, you must unprotect the workbook before clearing the check box.

   How?

   1. Click OK, point to Protection on the Tools menu, and then click Unprotect Shared Workbook.
   2. Enter the password if prompted, and then click OK.
   3. On the Tools menu, click Share Workbook, and then click the Editing tab.
6. When prompted about the effects on other users, click Yes.