How to Track Changes to a Workbook by Others in Excel 2007

1. Open Microsoft Excel 2007. Click on the “Office” button.
2. Select 'Open' from the menu. Find and highlight the file where you want to track the changes. Click the 'Open' button.
3. Select “Share Workbook” from the “Changes” group of the “Review” menu. Check the box beside “Allow changes by more than one user at the same time” in the “Editing” menu.
4. Select the “Advanced” menu. Press “Keep change history for” under the “Track changes” group. Type the number of days to maintain a history of tracked changes in the “days” box.
5. Click “OK” to apply the changes. Click “OK” to save the workbook.
6. Select “Track Changes” from the “Changes” group on the “Review” menu. Click “Highlight Changes.”
7. Check the box beside “Track changes while editing. This also shares your workbook.”
8. Click in the check box next to “When” to select it. Select “All” from the “When” drop-down box.
9. Click in the check box beside “Who.” Select “Everyone” from the “Who” drop-down box.
10. Check the box next to “Highlight changes on the screen.” Click the “OK” button.
11. Click the “Save” button to save the file.