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:

  1. Choose Review images Changes Track Changes Highlight Changes to display the Highlight ...

Get Office 2010 Made Simple now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.