Track and Report Changes in Excel
To overcome the limitations of the Track Changes feature, you can employ some help from Excel VBA and Excel's Change Events feature.
If you want to track any changes that either you or someone else has made to your data, you can use Excel's Track Changes feature, under Review → Changes (pre-2007, Tools → Track Changes). However, by doing it this way this function has a couple of drawbacks. When Track Changes is enabled, you are forced to share the workbook, whether you want to or not. Also, Track Changes makes many standard Excel features unavailable. We can easily conquer this problem with some code.
Be aware that this code is designed to track and record user changes only one cell at a time.