Show All

Turn off change tracking

1. Turning off change tracking 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 .

      When you copy or print the history, you may also want to save or print a separate copy of the shared workbook. If the workbook continues to change as you or others work on it, the history that you copied may no longer apply. For example, cell locations, including row numbers, in the copied history may no longer be current.

2. Do one of the following:

   If the shared workbook is protected, point to Protection on the Tools menu, and then click Unprotect Shared Workbook. Enter the password if prompted, and then click OK.

   If the shared workbook is not protected, click Share Workbook on the Tools menu. Click the Advanced tab, and then click Don't keep change history.