Windows

How to Fix Excel Document not Saved

Several users of Microsoft Excel report that they are faced with the issue where they get an error message of ‘Document not Saved’. They also experience the issue where their document doesn’t get saved at all despite trying all the actions. Microsoft has officially acknowledged this issue on their official website.

How to Fix Excel Document not Saved
How to Fix Excel Document not Saved

Despite what Microsoft was stating, we found that there are several other reasons as to why this issue was occurring and what are the workarounds present. Make sure that you follow the solutions from the start and work your way down accordingly. Also, we are assuming that you have an activated copy of Microsoft Office and are also an administrator.

What causes the Error messages ‘Document not Saved’, ‘Document not completely saved’, and ‘Document not Saved. Any previous saved copy has been deleted’?

After analyzing all the user reports and combining our research, we came to the conclusion that there were several different reasons as to why this issue might occur. Some of the reasons as to why you might experience the error messages listed are but not limited to:

  • Process interrupted: The saving process was interrupted by you either intentionally or unintentionally. This is usually done by pressing the ESC button or pressing the close icon present at the top-right side of the window.
  • Network issues: If you are saving the Excel document over the internet, there might be cases where because of a bad connection, the file sharing is interrupted and because of this, you receive an error message. Checking the network works here.
  • Hardware problems: There are also situations where you are saving the Excel file to external hardware such as a USB or hard drive. If that hardware is causing issues or the file is not getting through, you will experience the error message.
  • Permission issues: We also found some cases where users were saving the Excel files to a system directory where there were no permissions. If there are no permissions, the user will not be able to save the file and the error message will surface.

Before we move on to the solutions, we will try to save the existing Excel file which is open on your computer using another dummy file. This will save the contents of the file just in case and then we will proceed to troubleshoot the error message. Make sure that you are logged in as an administrator.

  1. Open a new Excel file. Now navigate back to the file which is causing the error and press Ctrl + C. This will copy the entire contents of the Excel file.
Copying Excel File Contents
Copying Excel File Contents
  1. Now move back to the dummy excel file which we just created. Now click on the top-left cell and then press Ctrl + V. This will copy the entire contents including the formulas to the new file.
Saving Excel File Contents
Saving Excel File Contents
  1. Once done, click on File > Save As and then select a local location which is present in your computer’s physical hard drive.

After saving the file, move on below to the troubleshooting methods:

Solution 1: Checking for Interruptions

There are also several cases where Excel is itself interrupted from saving the file to its required destination. This might occur in occasions where you accidentally press the Esc button or some other software/process prevents the saving from continuing.

Ending Problematic Processes
Ending Problematic Processes

Here, you should navigate back to the saving tab and then try saving again without pressing any other key. If this doesn’t work, press Windows + R, type “taskmgr” in the dialogue box and press Enter. The task manager should launch. Now check for any potential services which might disrupt the saving process. If you spot any, end the process and try saving again.

Solution 2: Checking Network Connection

There are numerous cases where you are saving the Excel file to a network location over a local network (for example, in organizations, employees sometimes save files remotely to another file location over the network). In these cases, the network should not have much delay and should have a stable property.

According to Microsoft, if your work network has disruptions every now and then and there is a high delay, there are chances that you will not be able to save the document. We also replicated the steps on our own systems and testing this statement positively.

If you are on an organizational network, try sending a remote file from other peer’s computer (considering he is already using the same network). If the same issue occurs, it means that there is some problem with the network connection properties and you should contact IT.

Solution 3: Checking Hardware Components

Another thing to check before we move on to the permissions is making sure that all your hardware is working properly. If you are saving the Excel file to an external flash/hard drive, then you should make sure that the connection is proper and seamless. Even if there is some physical damage to the external drive, you will receive this error message.

Checking External Hard drive
Checking External Hard drive

Hardware components also include your disk drive. If the disk head is not working properly, you will have issues accessing and writing files to your storage. Here you should check saving other files using software such as Microsoft Work and see if the issue occurs there as well. If it doesn’t, it means there is something wrong with the file location or with Excel itself. If the same issue occurs, you should dig deeper and make sure your hard drive is working as expected.

Note: You can also run a disk check to see for any errors.

Solution 4: Checking Permissions

If you are saving the Excel file to a location where your current user doesn’t have permissions, you will experience the error message as well. Each driver or folder has its own permissions which are usually granted to administrators (same with the ownership). However, some system folders might be restricted to one user or the main administrator (same goes for custom folders whose permissions have changed deliberately). In this solution, we will navigate to the directories and change the permissions.

Note: Make sure that you are logged in as a normal administrator. If you aren’t, make sure you log in with one as you will not be able to make changes in a normal account.

  1. Press Windows + E and navigate to the directory where you are trying to save the file. Now, go one step back and open the directory where this folder is present.
  2. Right-click on the folder and select Properties.
  3. Navigate to the “Security” tab and click on “Advanced” present at the near bottom of the screen. As you can see there are no proper permissions for your account in this case.
Advanced Security options
Advanced Security options
  1. Click on the “Change” button present in the preceding screen. It will be right in front of the owner value. Here we will change the owner of this folder to your computer account.
Changing ownership of File
Changing ownership of File
  1. Click on “Advanced” and when the new window comes forth, click on “Find Now”. A list will be populated at the bottom of the screen consisting of all the user groups in your computer. Select your account and press “OK”. When you are back at the smaller window, press “OK” again.
Finding your Username
Finding your Username
  1. Now check the line “Replace owner on sub containers and objects”. This will ensure that all the folders/files within the folder also change their ownership. This way you won’t have to proceed with all the process again and again for any sub-directories present. You can also check “Replace all child object permission entries with inheritable permission entries from this object” according to your preference.
Setting Ownership Preferences
Setting Ownership Preferences
  1. Now close the Properties window after clicking “Apply” and open it again afterward. Navigate to the security tab and click “Advanced”.
  2. On the permissions window, click on “Add” present at the near bottom of the screen.
Adding your Account for Full Control
  1. Click on “Select principle”. A similar window will pop up like it did in step 4. Repeat step 4 again when it does.
  2. Now check all the permission (giving full control) and press “OK”.
Granting Full Control to Profile
Granting Full Control to Profile
  1. Check the line “Replace all child object permission entries with inheritable permission entries from this object” and press Apply.
  2. Now, you have exclusive control of the directory in which want to save the Excel file. Try saving now and check if the issue still persists.

Solution 5: Launching Excel in Safe Mode

If all the above methods don’t work, we can try launching the Office Suite in Safe mode. When you launch the Office application is safe mode, it disables all the plugins which are running in the application and launching with only the basic editor. This might help troubleshoot problems where bad plugins are causing issues. Make sure that you are an administrator.

  1. Press Windows + R to launch the Run dialogue and type the following
excel /safe
  1. Now, press Enter. Excel will now be launched in save mode. Now try replicating the data into it and then try saving in safe mode. Troubleshooting whether the issue lies with some plugin or not.

Note: If you diagnose any plugin causing the issue, navigate to the plugin menu and disable it.

If the above method doesn’t work you can try starting your operating system in safe mode. This will help diagnose if any application is causing the problem. If the editor works normally there, then enable the applications one by one and identify. You can try the following article to boot your computer in Safe Mode:

How to: Start Windows 10 in Safe Mode

How to Enter Safe Mode in Window 7, Vista & XP

Leave a Reply

Your email address will not be published.

Expert Tip

How to Fix Excel Document not Saved

If the issue is with your Computer or a Laptop you should try using Reimage Plus which can scan the repositories and replace corrupt and missing files. This works in most cases, where the issue is originated due to a system corruption. You can download Reimage by clicking the Download button below.

Download Now

I'm not interested

Close