OneDrive File Issues

How to Fix Excel AutoSave Saving OneDrive Files to the Wrong Folder

Muhammad Talha Oct 1, 2026 870 views

Question details

Excel AutoSave disables itself and defaults to saving files in the local Documents folder instead of updating the synchronized OneDrive directory.

How to Fix Excel AutoSave Saving OneDrive Files to the Wrong Folder

Product: Microsoft Excel, OneDrive
Device & OS: Windows
Scenario: The user moved their OneDrive synchronization folder to a different drive, reinstalled Windows, and attempts to use Excel AutoSave on synchronized files.
Observed behavior: Excel fails to recognize the new OneDrive path, turns AutoSave off, and saves the cloud files as local copies in the Documents folder.

Before you start

Ensure that your OneDrive desktop client is actively running in the background and that you have verified the exact file path of the new OneDrive folder location on your secondary drive.

Solution 1Recommended

Open the Workbook Directly from the Synchronized OneDrive Folder

Ensure Excel recognizes the file as a cloud document by opening it directly through the active OneDrive sync directory rather than from the Recent Files list.

When you move your OneDrive folder to a new drive or reinstall Windows, old file shortcuts and Excel's 'Recent Files' cache still point to the previous file path. Opening a file from the recent list forces Excel to treat it as an unsynced local copy, which instantly disables AutoSave.

Verify OneDrive Sync Status

Click the OneDrive cloud icon in your Windows system tray (bottom right corner) and confirm that it says 'Your files are synced'.

Navigate to the New Folder

Open Windows File Explorer and navigate to your newly configured OneDrive drive location (e.g., D:\OneDrive).

Launch the Excel File

Locate your workbook inside this synchronized folder and double-click it to open it in Microsoft Excel.

Enable AutoSave

Once the file is open, locate the AutoSave toggle in the top-left corner of the Excel window and switch it to 'On'.

Open the Workbook Directly from the Synchronized OneDrive Folder

Clear Unpinned Recent Files: To prevent this issue from recurring, right-click any broken file paths in Excel's 'Recent' menu and select 'Remove from list'.

Solution 2

Adjust OneDrive Files On-Demand Settings

Modify your OneDrive configuration so Office applications can properly recognize and sync your files to the cloud.

Free Microsoft Office alternative

Try WPS Office for Seamless Cloud File Management

If you frequently encounter complex OneDrive synchronization errors and AutoSave failures in Microsoft Excel, consider switching to WPS Office. It provides a lightweight, highly compatible alternative with built-in cloud synchronization, eliminating the need to configure complicated local drive paths.

1. Download WPS Office: Visit the official WPS website and download the free WPS Office suite.
2. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing .xlsx files without losing any formatting.
3. Enable AutoBackup: Log into your free WPS account and turn on AutoBackup to safely store all your edits directly to WPS Cloud.

Fully compatible with Microsoft Excel (.xlsx, .xls) formatsBuilt-in WPS Cloud with reliable, hassle-free automatic savingLightweight installation with zero complex folder syncing rulesFree to use with a familiar, easy-to-navigate interface

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel AutoSave turn off automatically?

AutoSave requires the workbook to be actively stored in OneDrive or SharePoint. If you move your sync folder, experience a network drop, or open a disconnected local copy of the file, Excel automatically disables AutoSave to prevent overriding cloud data.

How do I change my default save location in Excel?

Go to File > Options > Save in Excel. Under the 'Save workbooks' section, you can update the 'Default local file location' to match your new OneDrive folder path so new files are routed correctly.

Does moving my OneDrive folder break existing file shortcuts in Excel?

Yes. Moving the OneDrive folder changes the absolute file paths on your computer. You must open files directly from the new location using File Explorer, because clicking them in Excel's 'Recent' tab will attempt to search the old, invalid path.

Document & File Issues