Why Excel Shows Last Opened Date Instead of Date Modified
Question details
The user wants to understand why the Recent files list in Excel displays the time a workbook was last accessed instead of its actual file modification time.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Viewing the Recent files list within the Excel application.
- Observed behavior
- Excel displays the 'last opened' or recent access timestamp in the Recent list, which differs from the 'date modified' shown in Windows File Explorer.
Keep in mind that the Recent list in Excel functions as a collection of shortcuts to help you quickly resume work, rather than a direct reflection of your file system's properties.
Check the True Modification Date in File Explorer
Since Excel's Recent list shows access history, you should use Windows File Explorer to see when the file was actually last saved or modified.
Excel's Recent files list is designed to help you quickly resume work. Therefore, it displays the time the shortcut was last accessed (opened) rather than when the file contents were changed.
Opening and closing a workbook without saving does not change its actual modification date, but it does update the timestamp in the Recent list.
Press the Windows Key + E on your keyboard to open File Explorer.
Browse to the folder where your Excel workbook is saved, such as your Documents, Desktop, or a synced OneDrive folder.
Change your folder view to 'Details' in the top menu and look at the 'Date modified' column to see the exact time the file was last saved.
Verify AutoSave and OneDrive Sync Status
If you expect the date modified to update automatically while working, check your AutoSave settings for files stored on OneDrive.
Try WPS Office for Clear and Intuitive File Management
If you find Microsoft Excel's file history and auto-save behaviors confusing, WPS Office offers a streamlined, user-friendly alternative. Enjoy a clear document manager, robust spreadsheet capabilities, and complete compatibility with Microsoft formats without the high subscription costs.
- 1. Download and Install: Visit the official WPS Office website and click 'Download' to install the software for free on your device.
- 2. Open the Application: Launch WPS Office and navigate to the 'Recent' tab on the global homepage to see your files.
- 3. Manage Your Files: View your documents with clear, intuitive timestamps and easily manage your local or cloud files without confusion.
Frequently Asked Questions
Why does the date change in the Recent list if I didn't save the Excel file?
The Recent list in Excel tracks when you last accessed or opened the file, functioning as an activity history. Opening a file updates this access log, even if you close it without making or saving any changes.
How can I remove a specific file from Excel's Recent list?
Right-click the file in the Recent list from the Excel start screen and select 'Remove from list'. This deletes the shortcut from your history but does not delete the actual file from your computer.
Does AutoSave affect the Date Modified property?
Yes. When AutoSave is enabled for OneDrive or SharePoint files, Excel continuously saves your changes in the background. This will frequently update the actual 'Date Modified' property in your file system.
Can I change the Recent list to show Date Modified instead?
No, Microsoft Excel does not currently offer a built-in setting to switch the Recent files list from 'Last Opened' to 'Date Modified'. You must use Windows File Explorer to sort your files by modification date.
