Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
If you watched the movie on sharing a workbook, you saw how you could allow other people to make changes to a workbook that you currently have open and that's great. But what if you want to be able to see those changes before you allow them, sort of like moderating the workbook and saying yes, I will except this change but I won't accept that change. Well, that's what the Track Changes feature is all about. So let's go to the Review tab over here and in the upper right corner in the Ribbon bar, choose Protect and Share. And we want to enable this box to share with track changes, and I am not going to put in a password, but something you should know.
If you do put in a password, then the people you're sharing it with will not be able to turn the Track Changes feature off. Well, maybe that's what you want. I am simply going to click OK and then click OK to confirm. Now, you can see up here in the title bar it says that we are in Shared Mode. Well, I'll change a few numbers and I'll take this 2950, let's make it 3000 and let's take that 4502, let's make that 4500, and maybe I'll take this 1099, I'll make it 1200. Okay. So now we have three changes.
Now, what we want to do is we want to see what changes have been made. Now, keep in mind the changes we are going to see, they could have been made by anyone who had this workbook opened not just by you. Not only that, but these changes could have been made at any time, not just when you're sitting there with the file open. So what we want to do here is we are still on the Review tab. Click Track Changes and than choose Highlight Changes. Let's move this out of the way, and we can see changes since the last time we saved and everyone, not just you, and we want to highlight the changes on the screen.
Click OK and now it highlights those cells that were changed. And you can roll over them and kind of like comments, it will tell you exactly what was changed. Now, here's the part about whether we want to accept the changes or not. So maybe click somewhere on the top of the worksheet and click Track Changes and we want to accept or reject changes. I am just going to save the workbook, click OK, click OK, and now we can find here's the first change. We have got the marching ants. We can Accept or Reject.
I'll click Accept and it goes to the next one. Now, if you have a lot of them and you decide that well, you want to take all of the changes, you can accept all of them, or if you don't like any of the changes you can Rreject all of them. Or except to the last one. I am going to reject this one and now I am going to accept all the rest of them. Now, once we are done, we want to take control of the workbook back to ourselves, and not let other people edit the workbook. So let's go over here and Unprotect shared workbook. And now we want to unshare the workbook, so click Share Workbook, deselect that, click OK, click Yes to confirm, and now it's no longer shared.
So this type of sharing I showed you is made for sharing in real time on your local internal network. If you have a lot of people who need access to this workbook, that's something you might want to consider.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 64853 Viewers
80 Video lessons · 124397 Viewers
52 Video lessons · 60322 Viewers
59 Video lessons · 46147 Viewers