Autosave option is the life-saving feature of Microsoft that save all the unsaved data of excel file automatically during the unexpected excel file crash or any other issue.
This option is very effective and able to deal with all types of data loss situations. Sometimes while reading/editing excel document user may face sudden power failure, excel app crash, or computer crashing issue, and the Excel docs are forced to close before the user can save the data.
To get rid of these data loss situations you can turn on the Autosave feature in Microsoft Excel to save the unsaved documents automatically.
Excel AutoSave not working on Windows PC!
Are you suffering from Microsoft Excel 2016, 2013 autosave not working issue? Microsoft Excel application has stopped autosaving Excel files during the editing session on Windows PC?
If your answer is YES then don’t worry as you can easily solve this issue and turn on the autosave feature on the excel application.
Here in this blog, you’ll read different techniques to quickly fix and repair Excel AutoSave not working problem.
Simply follow the given solutions one by one to turn on the automatically backup Excel files with ease.
Method 1: Check and Enable AutoSave in Microsoft Excel
Sometime user may forget to turn on the AutoSave option in Excel application; hence you have to enable them in order to use autosave feature for automatically saving and backing up Excel files on Windows computer.
Follow the below-given steps to check and enable the AutoSave feature on Microsoft Excel application:
Step 1: First you have to open the Excel file using Microsoft Excel 2016 and then click on the File then go to the Options
Step 2: Click on the Save tab present at the left pane, tick mark the Save AutoRecover information every * minutes and also tick mark Keep the last auto saved version if I close without saving box.
Step 3: Then, click on the Advanced tab present at the left pane and then tick mark Allow background saves box and at last click OK to save all the changes.
You will see that the Excel files and the application started doing autosave and backup files as given frequency.
Method 2: Fix and repair Excel AutoSave not working error
If you are still unable to use the Excel AutoSave feature in order to save and backup Excel files, then follow the below given steps carefully:
Trick 1: Find the Excel TMP files and re-save with extension.XLS/.XLSX
If you are using the Windows 7 system then you will find the Excel Temp file at the below given location:
If you are using the Windows 8 or 10 system then you will find the Excel Temp file at the below given location:
After finding the excel temp file, simply resave the file with the extension .XLS/.XLSX
Trick 2: Go with Open and Repair tool to fix damaged Excel
Step 1: First you have to open a blank Excel sheet, and then click on the File and Open
Step 2: Click on the location and path that stores the damaged Excel file
Step 3: From the Open dialog, choose the corrupted Excel file and click on the arrow to Open button > Click Open and Repair
Step 4: At last, you have to click on the Repair to Recover Excel data.
Trick 3: If you are still suffering from the Excel AutoSave not working issue then you should reinstall the Excel application on your computer.
How to Fix AutoSave is disabled for OneDrive, OneDrive for Business?
Sometimes you may face excel autosave not working saved in OneDrive, OneDrive for Business, or SharePoint. When a user hovers the mouse pointer over the AutoSave toggle then the tooltip will appear with the following message:
AutoSave Not Available. This file location doesn’t support AutoSave. Save to OneDrive or SharePoint Online if you want to use AutoSave.
This problem is fixed in Monthly Channel Version 1708 (Build 8431.2094) and higher. If you haven’t got any update then in order to get the latest update immediately follow the below-given steps:
First, open an Office app and navigate through the File > Account > Update Options > Update Now.
In case, you are still suffering from the experience or unable to update then follow the given steps:
Step 1: Open the Microsoft Office application and then click on the File > Open and navigate to the server location (OneDrive or SharePoint)
Step 2: Then, with the help of a web browser, try to open the file straight from SharePoint or OneDrive where the file is saved.
How to autosave Microsoft Excel file to Dropbox?
Steps for the latest Version
Step 1: Click on the File and then Options -> Save.
Step 2: In Outlook, click on the File > Options > Mail.
Step 3: Now, you have to confirm that the Save AutoRecover information every x minutes box is marked.
Step 4: Also confirm that Keep the last autorecovered version if I close without saving box is marked.
Steps for Microsoft Excel 2007
Step 1: Click on the Microsoft Office Button and go to the Excel Options then click Save.
Step 2: Now, you have to mark the Save AutoRecover information every x minutes check box.
Step 3: At the minute’s list, you have to specify how frequent you want the application to save your data being edited.
Step 4: Or you can also change the location where the Microsoft application automatically saves a version of files you work on.
That’s all about the Microsoft excel autosave is not working, it is hoped that after applying the above-given tricks and methods your Microsoft Excel file is started saving the file automatically.
If you have any other issues or query related to the excel file then you can contact us at http://ask.repairmsexcel.com