Tracking Changes

Sounds frustrating @PaulK05PaulK05 

A few things could be going wrong here:

1️⃣ Track Changes might not actually be enabled – Double-check under Review > Track Changes > Highlight Changes and make sure "Track changes while editing" is ticked.

2️⃣ File format issue – Track Changes only works in .xls (older Excel format). If your file is .xlsx, Excel quietly disables it. Try saving as Excel 97-2003 Workbook (.xls) and re-enabling Track Changes.

3️⃣ AutoSave interference – If the file is on OneDrive/SharePoint, Track Changes doesn’t work properly. Instead, check File > Info > Version History to see who edited what.

4️⃣ Changes aren’t saved before checking – Excel only logs changes when the file is saved. If your colleague made edits but didn’t hit Save before closing, they won’t be tracked.

Try these and see if it works! If not, let me know, and we’ll figure it out. 😊