How AutoSave and AutoRecover Affect Word and Excel Modified Dates
Question details
The user wants to understand why AutoSave may appear to change the Modified date of older Word and Excel files when they are opened and closed, and how AutoRecover works when AutoSave is disabled across OneDrive, Windows, Mac, and iPad.

- Product
- Microsoft Word and Excel files in local, OneDrive, and SharePoint storage
- Device & OS
- Windows, Mac, iPad
- Scenario
- A user opens older Word and Excel files with or without AutoSave enabled and needs to know whether the Modified date changes and how unsaved work is protected.
- Observed behavior
- Local files often keep their Modified date when opened and closed without saving, while AutoSave or OneDrive/SharePoint synchronization may update the timestamp for cloud files.
Before comparing modified dates, confirm whether each file is stored locally or in OneDrive/SharePoint and check the AutoSave toggle in the Word or Excel title bar.
Check the AutoSave toggle and file storage location before trusting Modified dates
Use this first because AutoSave only works on cloud-stored files and continuous saving can make the Modified date reflect the latest edit.
AutoSave is available only for files stored in OneDrive or SharePoint. It continuously saves changes and may update the file metadata when edits occur. Checking location and the AutoSave switch isolates this behavior from local files.
Open the older Word or Excel file and look at the top-left title bar for the AutoSave switch.
Click File > Info and view the file path. OneDrive or SharePoint locations can use AutoSave, while local paths cannot.
Close the file without making changes, then right-click the file in File Explorer or Finder, choose Properties or Get Info, and note the Modified date before and after.

Use AutoRecover instead of AutoSave for crash protection without continuous saving
Use this when AutoSave is disabled and you want recovery protection while minimizing changes to the original file metadata.
Compare date behavior separately for local, OneDrive, shared, and iPad files
Use this when you need to know exactly how metadata behaves across platforms or shared documents because sync services can behave differently.
Avoid Modified Date Confusion with WPS Office Writer and Spreadsheets
WPS Office is a free, lightweight Microsoft Office alternative that opens, edits, and saves Word and Excel formats with a familiar interface. It helps you manage local or cloud files without relying on OneDrive AutoSave metadata behavior, making migration seamless and predictable.

Frequently Asked Questions
Does opening and closing a Word document always change the Modified date?
No. Opening and closing without saving does not normally change the Modified date on local drives. On OneDrive or SharePoint, synchronization or metadata operations can update the timestamp even when content has not changed.
How does AutoSave differ from AutoRecover for modified dates?
AutoSave continuously writes changes to cloud files and may update the Modified date as soon as edits are saved. AutoRecover only creates recovery copies and does not modify the original file unless you save recovered content.
Can I stop OneDrive from updating modified dates on old Word or Excel files?
There is no user setting that completely guarantees OneDrive or SharePoint metadata behavior. Storing the file locally and keeping AutoSave off can reduce unexpected changes.
Does WPS Office change the modified date when opening Word or Excel files?
WPS Office normally writes only when you save. Opening and closing without saving generally preserves the original modified date, but cloud sync services may still update metadata.
Why should AutoRecover stay enabled if I disable AutoSave?
AutoRecover protects unsaved work after a crash or accidental close. It can save the latest working copy without requiring continuous cloud AutoSave.




