Sharing Your Workbooks and Tracking Changes
Unless you work on your own, you'll probably need to share some workbooks with your colleagues. Before you share a workbook, you can set Excel to track the changes your colleagues make so that you can easily review them without having to compare old and new versions of each worksheet.
Tracking Changes to a Workbook
To track the changes your colleagues make to a workbook, turn on the Track Changes feature. Excel then automatically shares the workbook for you.
To turn on Track Changes and share a workbook, follow these steps:
- Choose Review Changes Track Changes Highlight Changes to display the Highlight ...