Why Does Excel Autosave Keep Turning Off (Reason & Solution)

This article highlights the basic reasons for Excel autosave to keep turning off. AutoSave is a great feature in Excel, Word, and PowerPoint for Office 365 users. It saves your document automatically while you are working and allows you to avoid accidental loss of data.

Why Does Excel Autosave Keep Turning Off?

If you are a Microsoft 365 subscriber, you will see the AutoSave button at the top left corner of the Excel window. But you need to store the Excel document on SharePoint Online, OneDrive, or OneDrive for Business to use this feature. And then open it from OneDrive or SharePoint. Otherwise, AutoSave will keep turning off every time you reopen the Excel document.

Excel Autosave Feature

A Solution Regarding ‘Excel AutoSave Keeps Turning Off’ Issue

Now, follow the steps below to solve the issue.

📌 Step-1: Change Excel Options

  • First, press ALT+F+T to open Excel Options. Then, go to Save, and mark the checkbox for AutoSave files stored in the Cloud by default in Excel. After that, press the OK button.

Why Does Excel Autosave Keep Turning Off

Read More: How to See Where Excel Autosave Files Are Stored

📌 Step-2: Open OneDrive Settings

  • Now go to your OneDrive settings if installed as shown below.

📌 Step-3: Enable OneDrive Sync for Office Applications

  • Then, check the checkbox for “Use Office applications to Sync Office files that I open” from the Office tab as shown in the following picture. Next, press the OK button.

Read More: How to Turn Off Autosave in Excel

📌 Step-4: Save the Document on OneDrive

  • After that, save the document in the OneDrive folder on your PC. Then the AutoSave button should be enabled automatically. If not then click on the AutoSave button to enable it.

  • Alternatively, you can click on the AutoSave button if you have already saved your workbook to a different location, for example, D drive. Then Excel will prompt you to upload the document on OneDrive. Do that and the AutoSave feature will be enabled.

📌 Step-5: Open the File from OneDrive Only

  • Now open the file from OneDrive using File Explorer or the OneDrive app. Do not open the file from the earlier location on your PC i.e. from the D drive where the file was saved initially. Otherwise, the AutoSave button will keep turning off because that drive is not synced by OneDrive.

Things to Keep in Mind

You should not open the Excel document from its earlier location on your PC. Always open it from the OneDrive folder or the folder synced by OneDrive. Otherwise, the Excel AutoSave feature will keep turning off every time you reopen the file from there.


Now you know why AutoSave keeps turning off in Excel. Please let us know if the above steps helped you solve this issue. You can also use the comment section below for further queries or suggestions.

Related Articles

<< Go Back to Excel Autosave | Excel Files | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Md. Shamim Reza
Md. Shamim Reza

Md. Shamim Reza, a marine engineer with expertise in Excel and a fervent interest in VBA programming, sees programming as a time-saving tool for data manipulation, file handling, and internet interaction. His diverse skill set encompasses Rhino3D, Maxsurf C++, AutoCAD, Deep Neural Networks, and Machine Learning. He holds a B.Sc in Naval Architecture & Marine Engineering from BUET and has transitioned into a content developer role, generating technical content focused on Excel and VBA. Beyond his professional pursuits,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF