There can be several reasons behind getting this error message. In any case, if you are facing the same issue, this guide is for you. Here, we are going to mention several fixes that will help you get rid of the error message at hand. But before that, let us find out the scenarios that are likely to trigger this error message.
What causes Document not saved error in Microsoft Excel?
Here are some of the potential causes of the Document not saved error in Microsoft Excel:
It could be caused due to some interrupting program or process that is preventing Excel from saving your workbook. If the scenario is applicable, try terminating such processes to fix the error.If your user account doesn’t have sufficient folder permissions to save the workbook, you might experience this error message. Hence, you can try checking and granting folder permissions to fix the issue.You might experience the issue at hand if there is a network connection issue. This happens when saving the workbook to a network location.If there are some errors on the hard disk where you are trying to save your workbook, you might experience this error. So, check your disk drive health and fix the errors, if any.The error message might also be triggered due to a bad or problematic plugin. In that case, try running Excel in safe mode to fix the error.
Now that you know the scenarios that might cause the error message, let us check out the solutions.
Fix Microsoft Excel Document not saved error
Here are the fixes you can try to resolve the “Document not saved” error in Microsoft Excel:
1] Save the Excel workbook with a new filename
The first thing you can try to fix this error is to save your Excel workbook with a new filename. This is a kind of workaround and it might fix the problem for you. Just go to the File menu and click on the Save as option. Then, enter a new filename and save the workbook. See if you are able to save the workbook now without the “Document not saved” error or not. If not, you can also try saving the workbook at a different location and see if it works for you. Additionally, try saving the Excel workbook with a different extension. In case the above workarounds don’t work for you, try the next potential fix to resolve the error. Read: Fix VBA Run-time error Class not registered in Excel.
2] Move the original workbook to a new workbook
You can also try moving the content of the problematic workbook to a new fresh Excel workbook. Firstly, copy the content of your workbook using Ctrl+A and then the Ctrl+C hotkey. After that, just create a new workbook and paste the copied content into the new workbook. Now, save the new workbook and whether the error is fixed or not. If you still get the same error, you can try the next potential solution to fix the error.
3] Terminate the interrupting program or process
In some instances, the error might be caused due to some program or process interrupting Excel while saving the file at a particular location. So, if some other program is preventing Excel from saving the workbook, you can try closing the interrupting programs. You can open Task Manager using the Ctrl + Shift + Esc hotkey and analyze the running processes. And then, end the suspicious processes using the End Task button. After that, check if you are able to save your Excel workbook without the “Document not saved” error. If you still receive the same error while saving your Excel workbook, try the next potential fix to resolve the error. See: Fix Word, Excel, PowerPoint has run into an error.
4] Check folder permissions
You are likely to encounter this error message if your current user doesn’t have the required permissions at the location where you are trying to save your Excel file. Hence, check the permissions and if needed, change them. To change the folder permissions, you need to log in with an administrator account. After that, you can follow the below steps: You can now try saving the Excel workbook and see if the error is now fixed or not. If the problem still persists, you can try the next potential fix to resolve it. Read: Excel is waiting for another application to complete an OLE action.
5] Check Network Connection
If you are trying to save your Excel file to a network drive over a local network, make sure the network is stable and doesn’t have any lag issues. Network disruptions might prevent you from saving your file successfully. Hence, if the scenario is applicable, contact your IT admin and ensure that there is no problem with network connection properties. No issues with network connection properties and still getting the same error? Try the next potential solution to fix the error.
6] Check Hardware Components
In case you are trying to save your Excel workbook to an external flash or hard drive, make sure they are connected to your system properly. You might receive the error if there is some physical damage to your external drive. Apart from external drives, the issue might also be with your disk drives. If there is corruption or some other issues associated with your disk drive, you will face problems while saving files to your storage. Hence, you can try running a disk check to scan and repair bad sectors and file system errors on your hard disks.
To check hard disk errors, you can use Windows built-in tool called CHKDSK Tool. Simply right-click on the drive where you are trying to save your Excel workbook and press the Properties button. Then, go to the Tools tab, click on the Check button, and follow the prompted instructions to scan and fix file system errors. You can also try running the WMIC tool. It basically scans the health of your hard disks. See: Fix Compile error in hidden module in Excel or Word.
7] Start Excel in Safe Mode
If nothing worked for you, try launching Microsoft Excel in safe mode and see if the problem is fixed. Starting Excel in safe mode will basically disable all the plugins. So, if there is some bad plugin causing the error at hand, this should fix the error. Here is how to do that: In case this fixes the error for you, there must be some bad plugins causing the error. You can analyze such plugins and disable or uninstall them. That’s it!
How do I fix Document not saved error in Excel?
To fix the Document not saved error in Excel, you can try closing all the interrupting processes, changing your folder permissions, checking network connection, etc. Apart from that, you can also try scanning and repairing disk errors if that is what causing the error. Also, try launching Excel in safe mode. You can even try some workarounds like saving Excel workbook with a new filename. Now read:
Word cannot complete the save due to a file permission error.Cannot print a file; It opens as ‘Save as’ instead on a Windows computer.
