To view changes that were made after a particular date, select the When check box, click Since date in the When list, and then type the earliest date for which you want to view changes. To view all changes that have been tracked, select the When check box, click All in the When list, and then clear the Who and Where check boxes. To select the changes that you want to see, do the following: If prompted to select a value for a cell, click the value that you want, and then click Accept.Ĭlick Review > Track Changes, and then click Highlight Changes. To accept or reject each change, click Accept or Reject. To accept or reject changes to the entire workbook, clear the Where check box.Ĭlick OK, and then review the information about each change in the Accept or Reject Changes dialog box. To accept or reject changes that are made to a specific area, select the Where check box, and then type the cell reference of the worksheet range. To accept or reject changes that are made by all users, clear the Who check box. To accept or reject changes that are made by another user, select the Who check box and then, in the Who list, click the user whose changes you want to review.
To accept or reject changes that are made after a particular date, select the When check box, click Since date in the When list, and then type the earliest date for which you want to review the changes. In the Select Changes to Accept or Reject dialog box, do the following: If prompted to save the workbook, click OK. Note that in newer versions of Excel, the Track Changes button has been hidden. To keep change history for a longer than 30 days, enter a number that is larger than 30.Ĭlick OK and, if you are prompted to save the workbook, click OK to save the workbook.Ĭlick Review > Track Changes, and then click Accept or Reject Changes.
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. By default, Excel keeps the change history for 30 days and permanently erases any change history that is older than this number of days. In the Share Workbook dialog box, on the Editing tab, select the Allow changes by more than one user at the same time check box. Note that in newer versions of Excel, the Share Workbook button has been hidden. Therefore we highly recommend co-authoring, which is the replacement for Shared Workbooks. Shared Workbooks have limitations, and one in particular is the inability to edit using Excel for the web.
Be certain that you want to use this method before continuing.
0 kommentar(er)
