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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.