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:

Recent Posts

See All

Frequently Asked Questions, by phone

I have a warning message When does it happen? Can you send a screenshot to us? Also, if you can, please email the PDF input document to us (or upload it using the 'File' menu within StatementReader) a