How to View Excel File History, Edits, and Time Spent Editing
Question details
The user wants to find a way to view a comprehensive history of modifications, saves, and the total amount of time spent editing an Excel workbook.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Attempting to audit spreadsheet changes, monitor user modifications, or check total editing time for tracking or billing purposes.
- Observed behavior
- Excel automatically records basic file metadata like creation and last modified dates, but it does not provide a complete log of every edit or calculate total editing time by default.
Before you begin, note that Excel does not automatically track total editing time natively. To capture a complete history of edits and saves, you must enable specific tracking features or use cloud storage versions prior to making changes.
Use Highlight Changes to Track Spreadsheet Edits
Enable Excel's Track Changes feature to log modifications made by different users, which can be reviewed directly in the cells or on a separate history sheet.
In traditional desktop versions of Excel, the 'Highlight Changes' tool logs what was changed, who changed it, and when. Note that maintaining a very long history may increase the workbook's file size and memory footprint.
Open your workbook and click on the 'Review' tab located on the top ribbon.
Click on 'Track Changes' in the Changes group, and then select 'Highlight Changes' from the drop-down menu.
Check the box next to 'Track changes while editing'. Under the 'Highlight which changes' section, select the 'When', 'Who', and 'Where' parameters you want to log.
Check the option 'List changes on a new sheet' to generate a dedicated audit trail of all workbook modifications, then click 'OK'.
View File Versions Using Cloud Storage
Use OneDrive or SharePoint to automatically save and review complete prior versions of your Excel workbook.
Implement a VBA Macro to Log Editing Time
Since Excel does not natively record total time spent editing, you can design a custom VBA script to track when the workbook is opened and closed to calculate duration.
Track Spreadsheet Changes Easily with WPS Office
WPS Spreadsheet provides intuitive built-in tools for tracking changes, collaborating with teammates, and managing version history. View who made changes and when, seamlessly opening and saving Microsoft Excel files without losing format metadata.
- 1. Open your file in WPS Spreadsheet: Launch WPS Office and open your spreadsheet document.
- 2. Enable Track Changes: Navigate to the 'Review' tab on the top ribbon and click the 'Track Changes' button.
- 3. View the revision log: All subsequent cell modifications will be highlighted. You can accept or reject changes directly from the Review ribbon, ensuring complete control over the editing process.
Frequently Asked Questions
Does Excel automatically track the total time spent editing?
No. Unlike Microsoft Word, which has a native 'Total Editing Time' property in its file info, Excel does not automatically record editing duration. You would need to use third-party time-tracking software or build a custom VBA macro to log session lengths.
Why is the Track Changes option grayed out in Excel?
The Track Changes feature may be disabled if the workbook contains unsupported elements like Excel Tables, XML maps, or if the workbook is strictly protected. Additionally, you cannot track changes if the workbook is not shared.
Can I recover a previous version of my Excel file if I didn't turn on Track Changes?
Yes, but only if your file was saved to a cloud service like OneDrive or SharePoint. You can right-click the file in your cloud folder and select 'Version History' to restore an earlier, automatically saved version. Local files do not keep a version history by default.
How can I see who edited a specific cell in an Excel sheet?
If you are co-authoring a file hosted on OneDrive or SharePoint, right-click the specific cell and select 'Show Changes'. This opens a pane on the right side detailing the edit history for that specific cell, including the author's name and previous values.
