June 30, 2021
I have a spreadsheet that is going to senior managers. I have protected some columns and rows & left 4 columns free for them to add their approvals/comments.
However, I want to be able to track changes/additions as approvals make take a while to gather but we want to submit what we have at any given time to Payroll. We want to know then next time we access the report, changes made to the report so that we only then submit to Payroll, the new entries and not the previous.
July 16, 2010
Welcome to our forum!
You can track changes with Excel Online as shown here. i.e. open the file created in Excel on your desktop and you can get a full list and details of changes. It requires a Microsoft 365 license.
Otherwise, there is no change tracking functionality in earlier versions of Excel.