When you open Microsoft Excel the next time after you failed to save a file, Excel should open with a Document Recovery sidebar open. If that does not happen, you will find a Recovered section in the home screen with Show Recovered Files subsection. Click on any file listed under the section to reopen that version of the file.
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.
- The Excel files of Mac OS will definitely open in Windows computer. The reason for your problem may be the following reasons. Firstly check that the in that windows computer Microsoft Office is installed or not. If it was installed and not coming then check the versions of the Microsoft Office are same in the both the computers.
- On the File menu, select Save As. In the Save as Type list, select a file format other than the current file format. If you are using Microsoft Excel 2007 or a later version, save the file as.xlsx or.xlsm instead of as.xls. Try to save the workbook to another location.
- Check the AutoRecover folder! AutoRecover Excel on Mac is enabled by default, saving a file every 10 minutes. Therefore, for files that have been saved once, you can retrieve the edited content of the lost excel. Next, let's see how to recover Excel file not saved Mac in the AutoRecovery folder. Open the 'Finder'.
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:
C:UsersnameAppDataRoamingMicrosoftExcel
If you are using the Windows 8 or 10 system then you will find the Excel Temp file at the below given location:
C:UsersAppDataLocalMicrosoftOfficeUnsavedFiles
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
Recover Microsoft Excel File
Step4: 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.
Also Read: How to Fix Excel AutoRecover Not Working Issue
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.
Conclusion
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
Thank you…
Margret
Margret Arthur is an entrepreneur & content marketing expert. She writes tech blogs and expertise on MS Office, Excel, and other tech subjects. Her distinctive art of presenting tech information in easy to understand language is very impressive. When not writing, she loves unplanned travels.
Summary:
In this post i will discuss about some very frequently encountered Excel won’t save errors which generally occurs while trying to save Excel file or worksheet.
Let’s know, what are the different types of Excel file saving errors mostly rendered by Excel users? And most important of all how to fix Excel won’t save file errors?
Microsoft Excel is a spreadsheet program used world widely. This is a popular program and available on many operating systems such as Windows, Mac, iOS and Android.
Well, its popularity clearly shows how useful this is. And this powerful tool provides graphic, calculation, pivot tables and many others for performing various tasks easily.
But as it is said the Grass Is Not Always Greener on the Other Side, just like this, despite its popularity and uses Excel is also not free from ISSUES.
There are many types of errors faced by the Excel users time to time.
So, today here in this article I am going to describe some very frequently conquered Excel errors that occur while saving Excel workbooks.
Let’s proceed to our first important topic what kind of Excel save failed errors mostly encountered in Excel application.
What Kind Of Error Arise When You Save Excel File ?
Here are some most populated Excel save failed errors listed down, just check them out.
Please Note: The given methods might not save the entire latest changes, formatting and feature sets of the workbook specific to the Excel version that you are using. The given methods are proposed to obtain a usable, saved version of the file. And this requires you to save file to your hard disk by utilizing a unique file name
Error 1: Save The Workbook By Using A New File Name
Solution: In this case for saving the Excel workbook, try
- Click Save As, on the File menu.
- From the Browse option choose the location where you want to save your new Excel file. Then use a unique file name to save the workbook.
Error 2: Move The Original Worksheets To A New Workbook
Solution: This is another random error appears while saving Excel workbook, and to save it try
- Press shift + F11 to add a filler worksheet to your workbook
- Please Note: This sheet is needed because there should be at least one remaining sheet in a workbook after moving the entire related data sheets.
- Now, group entire worksheets (accept the filler) and to do so, click the first sheet and hold the Shift key, after that click the last sheet.
- Next, right-click the grouped sheets > and click Move or copy.
- And in the To Book list > click (New Book) > click OK.
Doing these steps will move the active (grouped) worksheets to a new workbook. And if your workbook contains VBA macros, then copy the modules from old workbook to the new workbook.
Error 3: Save The File As A Different Excel File Type
Solution: Now in this scenario, try this
- Click Save As, on the File Menu
- Then in the Save as Type list, select a different file format.
For example: If using Microsoft Excel 2007 or other versions, then save the file as .xlsx or .xlsm instead of as .xls.
Error 4: Save The File In HTML Format
Solution: In this case, try the given ways to save it.
- First, on File menu > click Save As.
- Then in the Save as type list > click Web Page.
- And lastly, click Save.
Well, these are some most commonly encountered errors that occur while saving Excel file.
After getting knowledge on how to save Excel file safely on your PC, now follow the troubleshooting steps to fix Excel save failed errors.
How To Fix Errors That Occur While Saving Excel Workbook?
Though there are various types of Excel won’t save changes errors pop up while trying to save an Excel file but luckily there are solutions for all the known errors.
Follow the complete solution to fix Excel save failed errors whether it occurred in any situation.
Solution 1: Restricted Permissions
You might be getting the error if you are having the restricted permissions to the folder on which you are saving the Excel file. So, when you save an Excel file you must have the following given permissions:
- Read permission
- Write permission
- Modify permission
- Delete permission
Please Note: If you do not have these permissions, then the Excel saving process cannot be completed.
Solution 2: Network Connection Lost
If you are using an Excel workbook and suddenly connection of the drives is lost in which your Excel file exists, then you might receive an error message while saving Excel workbook.
This happens because some parts of the workbook might not be downloaded to the local computer when you open the file from a network location.
Well, the Pivot Table Caches, the Microsoft Visual Basic for Applications (VBA) and the ActiveX objects are not downloaded to the local computer till they are accessed in the local Excel session.
So, if in case the network connectivity is lost, then Excel cannot access the file parts that were not downloaded to the local computer and as a result cannot save the Excel file.
Well to fix this follow the solution given in this article:FIX Excel Saving File at Network Location Fails Error
Solution 3: Antivirus Software Conflict
Well, due to the installed or running antivirus software, you might receive can’t save Excel file error message when you try to save an existing workbook.
In this case, you may receive an error message, as some antivirus programs quickly scan new files that appear on a computer. And this scan can sometimes interrupt the Excel save process and this might stop Excel from saving the file correctly.
So, try to disable the antivirus and try saving the file again.
Solution 4: File name Length
If you try to save or open an Excel file and the path of that file (including the file name) is more than 218 characters, then you might receive the error message:
Filename is not valid
To fix this read the article and fix it:
Helpful Article: How To Resolve ‘Excel Cannot Open The File ‘(Filename)’.Xlsx’ Error
Solution 5: Third-party add-in
If the Excel is not saved when you try running Excel in Windows safe mode, then this issue might be caused by the third party add-in or by the file that is one of the Excel startup locations. These files are by default loaded when you start Excel file.
So, check it and remove the possibility that a third-party Excel add-in or file is causing an Excel save issue, start the Excel file in safe mode and follow the steps:
- First Exit Excel.
- Then, click Start, > point to Programs.
- When you start Excel press Ctrl > and hold it till you get the message given below:
Excel has detected that you are holding down the Ctrl key. Do you want to start Excel in safe mode?
- After that click Yes.
- And try saving a new Excel file > and again re-save the same Excel file.
If the file saves correctly, then custom add-in or a file located in Excel startup location that might be the cause.
Locate and remove the add-in or the file to remove the problem, after determining the add-in or the file that is causing the problem, so contact the vendor who designed it. the vendor might have the additional information about the issue and an update that won’t cause the issue to occur.
Solution 6: Insufficient Drive Space
When you try to save the file to a floppy disk drive, or a local hard disk or a network drive and this causes the issues, then you need to make sure that the media must have the sufficient free space to let the file to save.
And this case you get the error message
Disk is Full.
Helpful article:You receive the “Disk is Full” error message when you save a workbook in Excel
After acquiring knowledge of the manual solutions to fix errors when saving Excel workbook. It’s time to move on to our next section i.e Recommended solution to fix can’t save Excel file errors.
Recommended Solution To Fix Excel Encountered Errors During Save
Sometime many Excel save failed error mostly arises either due to damage or corruption of Excel file. So, to deal with such cases easily and effortlessly, it’s recommended to go with the software solution i.e MS Excel Repair Tool.
Microsoft Excel File Download
Some highlighting feature of this recovery tool:
- As it is the most efficient tool to fix various errors, issues, corruption in the Excel file.
- With this unique tool you can easily repair multiple Excel files at one repair cycle.
- It also allows you to save entire recovered item in your preferred location.
- This supports the entire Excel versions and the demo version is free.
- It is easy to use and compatible with both Windows as well as Mac operating system.
Steps To Utilize MS Excel Repair Tool:
Final Verdict:
So, these are some Excel file won’t save errors that commonly originates at the time of saving up your work in Excel.
Well, I had tried my best to cover the entire information about Excel encountered errors during save.
So, just go through it and follow the given troubleshooting steps to fix Excel won’t save errors.
I love to get response from my reader’s side so if you have any additional questions concerning the ones presented in this blog. Or you have knowledge of any extra solutions that I missed out then share it with us in the comments section below.
Besides that you can also visit our Repair MS Excel, Facebook or Twitter social accounts.
That’s it!!!!
Margret
Margret Arthur is an entrepreneur & content marketing expert. She writes tech blogs and expertise on MS Office, Excel, and other tech subjects. Her distinctive art of presenting tech information in easy to understand language is very impressive. When not writing, she loves unplanned travels.
Comments are closed.