Excel File Last Modified Date and Time: How to Track It
Question details
The user needs to determine the reliable last modified or last saved date and time for an Excel workbook.
- Product
- Microsoft Excel and the connected file-storage or cloud synchronization service
- Device & OS
- not provided
- Scenario
- An Excel workbook is edited, especially on a mobile device, but its displayed modification timestamp changes back to an older time.
- Observed behavior
- The file timestamp does not consistently reflect the latest workbook changes and may be controlled by the mobile app, synchronization process, or storage service.
Identify where the workbook is stored, such as local device storage, OneDrive, SharePoint, or another cloud service. Confirm that the latest edits have finished syncing before checking the file properties or timestamp.
Check the cloud or file-storage service after synchronization finishes
Use this method when the timestamp changes after mobile editing or when the workbook is stored in a synchronized folder.
In Excel, open the workbook and choose File > Save, or tap the Save icon on a mobile device.
Keep Excel open until the cloud status indicates that the file is synced, or manually refresh the file list in the storage app.
In OneDrive, SharePoint, Files, or the relevant file manager, select the workbook, choose Details or Get Info, and read the Modified or Last modified value.
Read the last saved time from a desktop Excel workbook with VBA
Use this option for a desktop workbook when you need the workbook's built-in Last Save Time property.
Retrieve file metadata with Power Query
Use Power Query when you need to collect modified dates for one or more files from a folder or supported cloud connector.
Track and Save Excel-Compatible Workbooks with WPS Office
WPS Office is a free, lightweight alternative for opening, editing, and saving Excel-compatible workbooks with a familiar interface. It supports common spreadsheet formats and makes it easy to save a clean copy to local or cloud storage, where the storage service can report the reliable modified time.
- 1. Open the workbook in WPS Spreadsheet: Launch WPS Office, select Spreadsheet, and open the Excel .xlsx or .xls file from local or cloud storage.
- 2. Save the latest changes: Use Menu or File > Save, then wait for the connected storage service to finish uploading the file.
- 3. Check the stored file details: Open the file manager or cloud drive, select the saved workbook, and choose Details or Get Info to view its modified date and time.
Frequently Asked Questions
Does the Excel CELL(filename) formula return the file's last modified time?
No. CELL("filename") primarily returns the workbook path, file name, and active sheet. It does not reliably provide the file's last modified timestamp; check the storage service or use a metadata tool instead.
Why does an Excel file show an older modified date after I edit it on my phone?
The app may be showing a cached local copy, or synchronization may not have completed. Save the workbook, wait for syncing, refresh the storage location, and check the file's Details or Properties entry.
Can desktop Excel show the last time a workbook was saved?
Yes. A VBA macro can read ThisWorkbook.BuiltinDocumentProperties("Last Save Time").Value. The value may not be available for every workbook or may reflect the last save recognized by Excel rather than the cloud upload time.
What is the best way to track modified dates for many Excel files?
Use Data > Get Data > From File > From Folder in desktop Excel, or use a supported cloud connector in Power Query. The resulting file list can include a Date modified or Modified column for filtering and reporting.
