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

Get FREE Advanced Excel Exercises with Solutions!

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.


Conclusion

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

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Md. Shamim Reza
Md. Shamim Reza

Hello there! This is Md. Shamim Reza. Working as an Excel & VBA Content Developer at ExcelDemy. We try to find simple & easy solutions to the problems that Excel users face every day. Our goal is to gather knowledge, find innovative solutions through them and make those solutions available for everybody. Stay with us & keep learning.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo