• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 16. Collaborating with Colleague... > Tracking and Managing Colleagues’ Ch...

Tracking and Managing Colleagues’ Changes

Whenever you collaborate with a number of your colleagues in producing or editing a document, you should consider tracking the changes each user makes. When you turn on change tracking, any changes made to the workbook are highlighted in a color assigned to the user who made the changes. One benefit of tracking changes is that if you have a question about a change, you can quickly identify who made the change and verify that it is correct. In Excel, you can turn on change tracking in a workbook by pointing to Track Changes on the Tools menu and then clicking Highlight Changes.


In the Highlight Changes dialog box that appears, you select the Track changes while editing check box. Selecting this check box saves your workbook, turns on change tracking, and also shares your workbook, allowing more than one user to access the workbook simultaneously. You can use the controls in the Highlight Changes dialog box to choose which changes to track, but clearing the When, Who, and Where check boxes will have Excel track all changes. Now whenever anyone makes a change to the workbook, the change will be attributed to the user logged in to the computer from which the change was made. Each user’s changes will be displayed in a unique color. As with a comment, when you move the mouse pointer over a change, the date and time the change was made and the name of the user who made it appear as a ScreenTip.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint