- Turning off change tracking deletes the change history (change history: In a shared workbook, information that is maintained about changes made in past editing sessions. The information includes the name of the person who made each change, when the change was made, and what data was changed.). If you want to keep a copy of this information, print out the History worksheet (History worksheet: A separate worksheet that lists changes being tracked in a shared workbook, including the name of the person who made the change, when and where it was made, what data was deleted or replaced, and how conflicts were resolved.) or copy it to another workbook.
- On the Tools menu, point to Track Changes, and then click Highlight Changes.
- In the When box, click All.
- Clear the Who and Where check boxes.
- Select the List changes on a new sheet check box, and then click OK.
- 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 (shared workbook: A workbook set up to allow multiple users on a network to view and make changes at the same time. Each user who saves the workbook sees the changes made by other users.). 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.
- 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 (password: A way to restrict access to a workbook, worksheet, or part of a worksheet. Excel passwords can be up to 255 letters, numbers, spaces, and symbols. You must type uppercase and lowercase letters correctly when you set and enter passwords.) 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.