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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |