Turn on change tracking for a workbook
- On the Tools menu, click Share Workbook, and then click the Editing tab.
- Select the Allow changes by more than one user at the same time check box.
- Click the Advanced tab.
- Under Track changes, click Keep change history for, and in the Days box, type the number of days of change history that you want to keep.
Be sure to enter a large-enough number of days because Microsoft Excel permanently erases any change history older than this number of days.
- Click OK, and if prompted to save the file, click OK.
Note Turning on change tracking also shares the workbook.