Overall, 12 info types are available, but for this task, we will use just two of them.

This could be especially useful when the document is almost finished and your team is making the final revisions.

In an Excel file, you can review, accept or reject changes electronically by using the Track Changes feature specially designed for it.

Furthermore, you can monitor the latest changes by using the Watch Window.

To use the Excel tracking feature most effectively, there are a few points for you to remember.

So, whenever your turn on tracking in Excel, the workbook becomes shared, meaning that multiple users can make their edits simultaneously.

Not all Excel features are fully supported in shared workbooks including conditional formatting, data validation, sorting and filtering by format, merging cells, to name a few.

For more information, please see our Excel shared workbook tutorial.

In that case, convert your tables to ranges and remove XML maps.

Excels Track Changes is rather a log file that records information about the changes made to a workbook.

You can manually review those changes and choose which ones to keep and which ones to override.

Any edits you make to cell values are tracked, but some other changes like formatting, hidingunhiding rows and columns, formula recalculations are not.

After closing the workbook, any changes older than 30 days will be gone.

However, its possible to change the number of days for keeping change history.

You can select this box too to view full details about each change on a separate sheet.

At the cell level, edits from different users are marked in different colors - a colored cell border and a small triangle in the upper-left corner.

To get more information about a specific change, just hover over the cell.

For more detailed steps, please see How to share a workbook in Excel.

The numbers in the Losing Action column refer to the corresponding Action Numbers with information about the conflicting changes that were overridden.

As an example, please see action number 5 (Won) and action number 2 (Lost) in the screenshot below.

To remove them completely, turn off Track Changes in Excel.

To keep changes history for a longer period, perform these steps.

This can be done by using the CELL function in combination with the Watch Window feature.

Recover Unsaved Word Doc On Mac