O'Reilly logo

Excel 2003: The Missing Manual by Matthew MacDonald

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using Change Tracking

Comments are a great way for people to leave messages for each other in a spreadsheet. However, they become awkward if the workbook requires substantial changes, and they're downright aggravating if more than one person revises a workbook. For example, imagine a worksheet that tracks a team's weekly progress or one that represents a communal effort to create a business plan. In such situations, where more than one person needs to make substantial additions or changes to the worksheet data, comments just can't handle it all.

Excel provides another tool that makes it easier for groups of people to work together, and it's called change tracking . Change tracking makes sure that the changes made by different people are carefully logged, giving you the power to inspect each person's changes individually and reverse them if you choose. It's a little like keeping several versions of the same worksheet in a single spreadsheet file.

There are several reasons that you might consider using change tracking. These include:

  • You want to send a workbook to another person for review or editing. However, you want to be able to quickly spot the changes they make.

  • You want to have the last word on other people's changes to your workbook. In other words, you not only want to review changes, but also want to discard them if they aren't correct.

  • You want to distribute copies of your spreadsheet to several people at once. Once everyone has made their changes, you want to merge all these ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required