Office Settings & Configuration

Fix Excel AutoSave vs. AutoRecover File Timestamps Not Updating

Maira Mehtab Sep 28, 2026 870 views

Question details

The user is seeking clarification on why their local Excel file timestamps do not update automatically every five minutes despite having automatic saving features enabled.

How to Fix Excel AutoSave and AutoRecover File Timestamps Not Updating

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to track automatic saves of a local Excel workbook and noticing that the original file timestamps in the local directory are not changing.
Observed behavior: AutoSave does not periodically overwrite the local workbook. Instead, AutoRecover only saves temporary recovery information in the AppData folder, causing the original file's timestamp to remain unchanged until manually saved.

Before you start

Determine whether your Excel file is stored locally on your hard drive or in the cloud (such as OneDrive or SharePoint), as Excel handles automatic saving differently depending on the storage location.

Solution 1Recommended

Configure AutoRecover Settings for Local Files

Verify your AutoRecover settings to locate the temporary backup files created for crash recovery.

AutoRecover is designed to save a temporary backup of your work strictly in case Excel crashes or closes unexpectedly. It does not overwrite your original file automatically. By default, these temporary files are stored in a hidden AppData directory.

Access Excel Options

Open Microsoft Excel and click on the 'File' tab located in the top-left corner of the window. Then, select 'Options' at the bottom of the left-hand menu.

Navigate to Save Settings

In the Excel Options dialog box, click on 'Save' in the left pane to view how workbooks are saved.

Review AutoRecover Location

Look for the 'AutoRecover file location' field. Ensure the 'Save AutoRecover information every X minutes' box is checked. Note the folder path (typically C:\Users\<username>\AppData\Roaming\Microsoft\Excel\) so you know where recovery files are stored.

Configure AutoRecover Settings for Local Files

Crash Recovery Only: These AutoRecover files are strictly used to restore unsaved changes after an unexpected shutdown. You must still manually click the Save button to update your original file and its timestamp.

Solution 2

Enable Continuous AutoSave Using Cloud Storage

If you want your file to save continuously and update automatically without manual intervention, you must store it in the cloud.

Solution 3

Set Up Macros for Local File Auto-Saving

Use a VBA macro if you strictly need a local file to overwrite itself automatically at specific intervals.

Free Microsoft Office alternative

Easily Manage Local File Backups with WPS Office

If you are frustrated by Microsoft Excel's cloud-only AutoSave restrictions, WPS Office provides a robust, easy-to-use Local Auto Backup feature. It ensures your data is always safe without forcing you to use cloud storage, all while remaining highly compatible with your existing documents.

1. Download and Install: Download WPS Office for free from the official website and follow the simple installation prompts.
2. Open Your Spreadsheet: Launch WPS Spreadsheet and open your existing Excel workbooks with perfect formatting retention.
3. Configure Local Backups: Navigate to Menu > Settings > Backup Settings to easily set up automated local backups that fit your workflow.

Free, lightweight, and fast office suiteFully compatible with Microsoft Excel formats (.xlsx, .xls, .csv)Clear and accessible local Auto Backup settingsFamiliar user interface with no learning curve required

microsoft office alternative - wps office

Frequently Asked Questions

Does the AutoRecover five-minute interval start when I make a change?

Yes, the timer generally starts after you modify the document. If no changes are made to the workbook, Excel will not create redundant AutoRecover files in the background.

If my system freezes, can I use the AutoRecover file to restore my workbook?

Yes. After a system crash or freeze, restart Excel. The Document Recovery pane should automatically appear on the left side of the screen, allowing you to recover your unsaved work using the latest temporary AutoRecover file.

Will I see an updated version of my local Excel file in its original folder every five minutes?

No, AutoRecover saves temporary recovery data in a hidden AppData folder, not in your original file's location. Your original file's timestamp will only update when you manually execute a Save command.

Can I automatically save a local Excel file without physically clicking Save?

Not natively without using cloud storage. Excel's built-in AutoSave requires the file to be stored on OneDrive or SharePoint. For local files, you must either manually click Save, press Ctrl+S, or set up a custom VBA macro to automate the saving process.

Office App Problems