To track Excel workbook changes, the most direct way is to enable the "Revision" function, click "Review" > "Revision" in turn to start recording the modification; you can view, filter and accept/reject changes; if you turn off the function, stop recording; if you need to compare two versions, you can achieve it through the "Compare Workbook" function; at the same time, please note that the file format should be .xlsx or .xlsm, set the user name to facilitate identifying the modifyer, and the history cannot be restored after closing the revision.

The most straightforward way to track changes in Excel workbooks is to use the "revision" feature that comes with Excel. It can record who modified what content when and facilitate multiple people to check the changes when collaborating.

Enable the "Revision" function to record changes

Excel provides a Revision mode that automatically records changes made to worksheets. This feature is suitable for use when teams edit a file together.

• After opening the Excel file, click the "Review" tab in the top menu bar
• Find the "Revision" button in the "Change" group and click Enable
• Once enabled, all newly added, deleted or modified content will be marked

Note: This feature can only be used in normal worksheets and cannot be used in protected worksheets or shared workbooks (legacy features).

View and accept/reject changes

Once the revision is turned on, you can check who made what changes at any time and decide whether to keep them.

• Click Review > Change > Accept or reject changes
• Excel lists each modification item one by one, and you can choose to accept or reject
• If you want to view only changes by specific people, you can filter users in the Change window

If you want to keep the traces of modification but no longer continue recording, you can click the "Revision" button again to turn off the feature.

Compare two versions using the Compare Workbook feature

If you have saved two different versions of Excel files, you can use the Compare Workbook to see the differences between them.

• Open the original file and select Compare > Compare Workbook in the Review menu
• Select another version of the file, and a new window will pop up in Excel to show the difference between the two.
• All modifications will be listed in the "Revisions" window, and accept or reject operations are also supported.

This approach is suitable for temporarily checking changes between the two versions without continuously opening the revision.

Tips and precautions

• File format problem : Make sure the file is saved as a macro-enabled workbook (.xlsm) or standard workbook (.xlsx), otherwise some features may not be available
• Username settings : You can set your username in "File>Options>General", so that others know who made the changes
• History will not be permanently preserved : If you close the file and reopen it, the revision record will still exist, but if you manually close the revision function and save the file, you cannot restore the previous modification details.

Basically, these methods are all. By mastering these functions, you can clearly know what changes have occurred in the Excel file.

The above is the detailed content of how to track changes in an excel workbook. For more information, please follow other related articles on the PHP Chinese website!