By default, the change history is kept for only 30 days. Other changes that are not tracked include hiding / showing rows and columns, comments, and cell values ?that change due to formula recalculation.ģ. Any data stored in the cell is tracked, but other changes, such as formatting, are not tracked. Turning tracking on does not mean that every change you make will be recorded. You can manually see what data has been removed or added, but you will have to make changes to the table yourself.Ģ. Basically, it is a log file that everything is written to and that’s it. Turning tracking on does not mean that you can revert the spreadsheet back in time to a previous state by undoing the changes. There are a few things to keep in mind about tracking functionality in Excel:ġ. You can easily view all changes right on the sheet, and accept or reject each change. You might want to keep track of when the change was made, who made the change, which cell the change took place, and what data was changed.Įxcel has built-in tracking functionality that can handle all of the above cases.
Are you looking for a way to track changes made to an Excel spreadsheet? There are many cases where you need to share a file with multiple people and keep track of what changes have been made.
