Table of Contents
About the Author
Reviews and Awards
- Video Recovery
- SD Card Recovery
- Recycle Bin Recovery
- Recover Data from USB
- Recover Deleted Emails
- Hard Drive Not Showing Up in Windows
- Recover Unsaved Word Documents
- Recover Deleted Files
- Recover Files from Virus Infected Hard Drive
- Best Free Photo Recovery Software
- Recover Files from Formatted Hard Drive
What Is AutoSave in Excel
AutoSave is a feature available in Microsoft Excel, Word, PowerPoint, and Office 365 that can save your files automatically at a certain interval when you are working.
In Microsoft Office, you can use the AutoSave (namely AutoRecover) tool to temporarily keep changes in a directory on your local computer. You can change the Autosave location flexibly. In Microsoft 365, AutoSave is enabled by default when a file is stored on OneDrive, OneDrive for Business, or SharePoint Online.
With AutoSave enabled, Excel will keep your file when an expected problem occurs such as a program crash, sudden power cut-off, or system corruption, which will ensure minimal data loss. Now, let's check how to enable AutoSave in Excel on Mac and Windows 10.
How to Turn on AutoSave in Excel 2019/2016/2013/2010/2007
In this part, we will show you how to turn on AutoSave in Office Excel on Mac and Windows computers. Besides, steps to enable AutoSave in Office 365 are also explained.
Turn on AutoSave in Excel Mac
macOS crash and power failure occur accidentally. If you are working hard on a crucial Excel but don't save it when Excel stops working, the AutoSave would be helpful. Follow to see how to turn on AutoSave in Excel on Mac.
Step 1. Open Excel on your Mac. Click Excel in the top toolbar and click "Preferences".
Step 2. In the Excel Preferences box, click "Save" under Sharing and Privacy.
Step 3. Select "Turn on AutoSave by default" and "Save AutoRecover info every xx minutes". Then, click "OK". That's it.
Turn on AutoSave in Excel Windows 10
It's simple to enable the AutoSave feature in Excel on Windows 10/8/7. Here are the steps.
Step 1. Open Excel on your computer. Go to "File" > "Options".
Step 2. Click Save on the left panel. Select "Save AutoRecover information every xx minutes" and "Keep the last autosaved version if I close without saving" by ticking the boxes ahead. Click "OK" to save the changes.
Turn on AutoSave in Excel Office 365
If the AutoSave doesn't work in Excel of Office 365, turn it on and change the settings with the ways below.
Step 1. Start Excel, click "File" > "Options".
Step 2. In the Options dialog box, click on the "Save" button. Check the Option of "AutoSave OneDrive and SharePoint Online files by default in Excel". Then, your Excel work will be saved in real-time.
Step 3. Select "Save AutoRecover information every xx minutes". We recommend that you keep the auto-save interval as short as possible. Then, click "OK" to keep the change.
These are the quick methods to turn on AutoSave in Microsoft Office and Office 365. You may have noticed that we mentioned AutoSave and AutoRecover What's the difference between them?
Excel AutoSave and AutoRecover
In simple words, AutoSave is a new feature in Excel Office 365, while AutoRecover is the name of the auto-save feature in prior versions, Excel 2010/2013/2016/2019.
AutoSave is turned on by default in Microsoft 365. AutoRecover does exactly the same thing as AutoSave and keeps changes in your Work on your local computer. Once you encounter a data loss without saving, you can recover the unsaved Excel from temporary files. You can retrieve Excel from the last AutoRecovered version.
Excel AutoRecover helps you retrieve unsaved files after an accidental closure or crash. It allows you to restore to the last saved version which displays in the Document Recovery pane when you start Excel next time.
How to Restore Unsaved Excel Files Using AutoRecover
If you lose your Excel work after a fortuitous closure or crash, you can recover unsaved Excel files by using the AutoRecover features in 2 Ways.
1. Recover Unsaved Excel in the Document Recovery
Excel AutoRecover allows you to restore from the last saved version that appears in the Document Recovery pane when you re-start Excel.
2. Retrieve Unsaved Excel from Temporary Files
Step 1. Open your Excel, choose "File" > "Open" > "Recover Unsaved Workbooks".
Step 2. Select the workbook you lost from the list. Then, open and save the Excel.
You see, if AutoSave is enabled in Excel, recovering unsaved data is very easy. But keep in mind, that Excel AutoSave or AutoRecover are not an alternative to manual saving. Save your work in real-time manually to prevent data loss.
How to Recover Deleted Excel Files in Windows 10 and Mac
Accidentally deleting Excel files happens frequently, which brings big trouble for many users. Don't panic. You can use EaseUS Data Recovery Wizard to recover deleted or lost Excel, Word, photos, videos, audio, emails, or other files without any effort.
This reputable data recovery and repair tool is also good are repairing corrupted Excel files efficiently. Free download this software and learn to get back permanently deleted Excel in three steps.
Step 1. Select location and click "Scan"
Choose the drive or a specific folder on Desktop or somewhere else where you lost the excel files, and click the "Scan" button.
![select the location of the Excel files](/images/en/data-recovery/drw-pro/screenshots/recover-documents-step1.png)
Step 2. Locate your excel files
To quickly find the Excel files from the scan results, click the "Documents" option in the left panel. Choose "Excel", and click "Preview" to check if the Excel files are the wanted ones.
![scan the lost excel files](/images/en/data-recovery/drw-pro/screenshots/recover-documents-step2.png)
Step 3. Recover Excel files
Finally, select the desired Excel files and click the "Recover" button. Then, select a folder to save the Excel files to another location.
![recover Excel files](/images/en/data-recovery/drw-pro/screenshots/recover-documents-step3.png)
Addition Information About Excel AutoSave
When you are using AutoSave in Excel, you may meet the following issues. Let’s check their methods together.
1. Why can't I turn on AutoSave in Excel?
AutoSave settings may don't work for some files, especially large files, or files stored on SharePoint. You can go to "File > Options > Save" and re-check the AutoSave box.
2. How to change AutoSave Location in Excel?
Usually, the AutoRecover file location path is C:\Users\Owner\AppData\Roaming\Microsoft\Excel. You can change the file location as you need in the ways below.
Step 1. Open Excel. Click the "File > Options" ( In Excel 2007, click the Office button > Excel Options).
Step 2. Click Save in the left bar and find "AutoRecover file location".
Step 3. Delete the default path and enter your location. Click "OK" to save the change.
3. How to disable AutoSave in Excel?
The way to turn off AutoSave is the same as the way to enable it. You can follow the steps of how to turn on AutoSave in Excel 2016 to find the AutoSave option, and then uncheck it.
Was This Page Helpful?
![](/images/en/icon/brithny.jpg)
Brithny is a technology enthusiast, aiming to make readers' tech lives easy and enjoyable. She loves exploring new technologies and writing technical how-to tips. In her spare time, she loves sharing things about her game experience on Facebook or Twitter.
![](/images/en/icon/grantham.jpg)
Cedric Grantham is a senior editor and data recovery specialist of EaseUS. He mainly writes articles and how-to tips about data recovery on PC and Mac. He has handled 10,000+ data recovery cases and is good at data recovery of NTFS, FAT (FAT32 and ExFAT) file systems, and RAID structure reorganization.
-
EaseUS Data Recovery Wizard is a powerful system recovery software, designed to enable you to recover files you’ve deleted accidentally, potentially lost to malware or an entire hard drive partition.
Read More -
EaseUS Data Recovery Wizard is the best we have seen. It's far from perfect, partly because today's advanced disk technology makes data-recovery more difficult than it was with the simpler technology of the past.
Read More -
EaseUS Data Recovery Wizard Pro has a reputation as one of the best data recovery software programs on the market. It comes with a selection of advanced features, including partition recovery, formatted drive restoration, and corrupted file repair.
Read More
Related Articles
-
RAID 0 Data Recovery | Recover Data from Corrupted RAID 0 Array
Cedric/2023/07/20
-
M3 RAW Drive Recovery Crack Alternative with License Code/Key [Safe and Clean]
Tracy King/2023/11/27
-
How to Correct #DIV/0 Error in Excel | Check Your Full Guide 2024
Tracy King/2024/01/04
-
Files/Folders Disappeared from Desktop Windows 11/10 [Restore Quickly]
Cedric/2023/07/20