Improving Excel with Python (Day 5 of 5)

My starter scripts in January 2021:

Track changes in Excel

My most hated feature of Excel is tracked changes.

Tracked changes in Excel are presented in a separate tab, away from the data that has been changed, presenting challenges to any user who needs to trace back over the changes that have been made.

I explored creating a more intuitive display of tracked changes using cell comments to show a full audit trail of the changes made.

Here’s a snippet that logs the changes made in Excel by updating the cell comments with a time and the cell’s previous value.

This brings my short exploration into solving Excel problems with Python to a close.

But the possibilities are endless, so if you have ideas, please get in touch:)

---

Have a look at the full code I used, here: