How to Merge Changes from Different Excel 2013 Users
Transfer Sheets from One Excel 2013 Workbook to Another
How to Embed and Link Data from Excel 2013 into Word 2013

How to Turn on Change Tracking in Excel 2013 Workbooks

Select the Track Changes While Editing check box.

Doing this turns on change tracking and automatically turns on file sharing for the workbook.

By default, Excel selects the When combo box and chooses the All option from its drop-down menu to have all changes made to the workbook tracked. To track the changes only from the time you last saved the workbook, choose the Since I Last Saved item from the When drop-down menu.

To track all changes that you’ve not yet reviewed (and decided whether to accept), you choose the Not Yet Reviewed item from the When drop-down menu. (Most often, you want this option so that you can use the Accept/Reject Changes option on the Track Changes command button’s drop-down menu to review each person’s changes and decide whether to keep them.)

To track changes from a particular date, choose Since Date from the When drop-down menu: Excel then inserts the current date into the When combo box, which you can then edit, if necessary.

  • Add a Comment
  • Print
  • Share


Promoted Stories From Around The Web

blog comments powered by Disqus
Share Excel 2013 Workbooks Saved on Your SkyDrive
How to Protect a Document in Excel 2013
How to Cut and Paste in Excel 2013
How to Save Excel 2013 Worksheets as HTML Files
How to Assign Graphic Images as Excel Worksheet Backgrounds