Excel 2016 is the latest version released by Microsoft. It is the most advanced and popular spreadsheet program. This latest version of Excel is smooth and modernized, with entire previous existing features and a few more that provide greater ease of use. Now, it becomes easy to work with a large amount of data. This is overall a great choice for any medium and large business for managing their crucial data without any hassle.
Apr 05, 2016 This site uses cookies for analytics, personalized content and ads. By continuing to browse this site, you agree to this use. Excel for Mac crashes and slow performance WORKAROUND Excel prompts you to grant access to files and then hangs or shows a warning that it cannot open the.xlsx file because the format or extension is not valid FIXED Scrolling between cells in Excel 2016 for Mac is slow. Excel for Mac features and add-ins issues.
But apart from its popularity, many users are experiencing “Excel 2016 has stopped working with Windows 10” error message. Whenever the user tries to start Excel 2016 on Windows 10, the application starts crashing and freezing and start showing error. This is really a very frustrating issue, let define it best with the user experience:
I have been successfully creating and opening files in Excel 2016, but since I installed Windows 10. My excel files start crashing continuously and show error Excel 2016 has stopped working with Windows 10, I tried opening the file with the inbuilt Open & Repair utility but found no luck there.
This is really the very annoying issue and has no idea how to fix the error. Anyone have any idea how to get rid of this. Please help!!!
Original post from Microsoft Community
Well, there is no any definite reason that is responsible for this issue. This issue causes the program to stop working correctly and then Windows will close the program and informs the user if a solution is available.
There is no any definite fix for Microsoft Excel has stopped working 2016 issue; therefore in this article, we are providing some possible workarounds that worked for many users who faced this weird issue. These solutions are very common and you can try them in your case to solve the error.
Solution to Fix Microsoft Excel 2016 Has Stopped Working on Windows 10
# 1 – Utilize Windows 10 File Explorer
The Excel app crashing issue is generally faced by the users on Windows 10. Some users practiced that turning on list view in File Explorer solve the issue. So it is recommended if you are experiencing the same issue then try this solution and check whether the issue is solved or not.
To do so follow the steps:
- Start File Explorer.
- Then in the View tab under Explorer‘s ribbon, choose the List as a default view.
Now check the issue is solved or not. Microsoft is aware of this problem and it will push some updates that help you to get rid of the error. But till then utilize this workaround.
You May Also Like:
# 2 – Disable Add-ins (Hit and Trial method)
It is found that in some cases corrupted add-ins also contribute to this problem. So if that is occurring on your system also, then try disabling the add-ins individually and check if the issue is solved or not. This is a “hit and trial” method.
Follow the steps:
- Go to File > Options in the Microsoft Excel,
- Then in the Excel Options window, choose Add-ins against Manage > click Go.
- Lastly, disable add-ins individually and check the issue is solved or not.
Hope this solution will help you to solve the issue but if not then follow the online repair solution to get rid of Microsoft Excel has stopped working 2016 error.
#3 – Perform Online Repair
If office application in Excel is not working properly, then try the online repair process, this will fix the problem. Follow the steps to do so in Windows 10:
- First, right-click on the Start button > choose Programs and Features on the pop-up menu.
- Now right-click the Microsoft Office product that is needed to repaired > choose Change.
Please Note: If you are having a suite such as Office 365 Home or Office Home and Student 2013 or 2016, then search for the suite name, even if it is only a particular application that is needed to repair like Word or Excel. If you are having a separate application like Word or Excel then search for the application name only.
- From the “How would you like to repair your Office Programs” screen > choose Online Repair to assure everything is fixed.
- Then select Repair. The Quick Repair option is also available; this runs faster but only detects and substitutes the corrupted files.
Please Note: If the copy of Office is MSI-based, then choose Repair > click Continue. If you require help to figure out whether your Office is Click-to-Run or MSI-based, then follow the given below process.
- Open Office application, like Outlook or Word.
- Then go to File > Account or Office Account.
- If you notice an “Update Options” item, then you are having a Click-to-Run installation. And if you don’t notice any “Update Options” item, then you are having an MSI-based install.
- After that follow the instructions on the screen to complete.
Hope this process will help you to fix the excel 2016 issue in Windows 10 but if still it is not solved then go for the fourth solution.
#4 – Execute Offline Repair Of Office Installation
Office 2013 or 2016 comes with the ability to repair the Office installation offline. Repairing install not only fixes the problem but also fixes other issues related to the Office package.
Here follow the steps to do repair it:
- Open the Office application and then utilize the Repair process in Control Panel > Programs and Features
- Or else you can open it by typing Add or Remove Programs on the Start screen or in Search.
- Then, in Windows 10, open Control Panel > find Programs and Features or Add or Remove Programs.
- In the next window > select Repair option:
- The Repair option in the Office setup starts repairing itself. You can observe the progress indicator during this
- Lastly, as the Office installation is repaired successfully, you are asked to restart the system for applying the changes > click Yes option
- After restarting the system launch the newest Office 2016, and you will find that the problem is resolved now.
Automatic Solution to Repair Excel 2016
If you don’t want to repair your corrupt excel 2016 with the manual solution or you are unable to solve the issue with the excel 2016 file manually then, in this case, make use of the MS Excel Repair Tool, this is the best repair utility that is designed to fix all sorts of corruption, errors, damages in Excel file and also recovers entire data including the charts, worksheet properties cell comments, and other important data easily. It is a professional recommended solution to repair corrupt excel file. This is the unique tool that repairs multiple files at one time and restores entire data in the preferred location. This supports all versions of Excel file and compatible with both Windows as well as Mac OS.
Steps to Utilize MS Excel Repair Tool:
![Excel 2016 for mac not opening Excel 2016 for mac not opening](/uploads/1/2/4/8/124805639/846229505.jpg)
Conclusion:
Hope by following the workarounds given in the article you are able to fix the Excel 2016 not responding Windows 10 error message
There are many cases seen when the users are informing about Excel 2016 crashing in Windows 10.
So, here follow the working solutions to fix the Excel has stopped working 2016 in Windows 10 error.
Apart from that always create a valid backup of your crucial Excel data and as well scan your system with good antivirus program for virus and malware infection.
If, in case you have any additional questions concerning the ones presented, do tell us in the comments section below or you can also visit our Repair MS Excel Ask Question
Good Luck….
Repair MS Excel 2016 Has Stopped Working On Windows 10
Repair MS Excel 2016 Has Stopped Working On Windows 10
Description
Solution 1- Utilize Windows 10 File Explorer, Solution 2: Perform Online Repair and another solutions to fix Excel 2016 has stopped working on Windows 10 error.
Author
Repair MS Excel Blogs
Publisher Logo
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:
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 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 3: From the Open dialog, choose the corrupted Excel file and click on the arrow to Open button > Click Open and Repair
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…
[Solved] How to Fix Microsoft Excel 2016 Autosave Not Working?
[Solved] How to Fix Microsoft Excel 2016 Autosave Not Working?
Description
Want to Fix Microsoft Excel 2016 Autosave Not Working, then follow the given tricks and tips. All the given solutions are very effective and simple.