Instructions on how to fix Excel error of not allowing oversave

Excel does not allow overwriting, making it difficult for you to save the file? Don't worry because the solution to this problem is really very simple.

For convenience in managing files on the computer. After editing the file, you can save the file with the same name you saved before. And this is called file name overwriting. But in reality, many people encounter a situation where Excel does not allow overwriting .

If you only open the file a few times, it's okay. But if you have to edit multiple times and each time you have to save with a new name, it will be very inconvenient. If you want to learn the cause and how to fix this error when saving Excel files, please immediately refer to the content revealed by TipsMake below!

Instructions on how to fix Excel error of not allowing oversave Picture 1

What is the situation in Excel that does not allow overwriting?

Usually when you open an Excel file or a Word file on your computer to edit. After editing, just press Ctrl + S and the file will immediately be saved with the name you saved before. However, there are times when the Excel file will not let you save with the old name and at this time you will receive a message like below.

Instructions on how to fix Excel error of not allowing oversave Picture 3

Cause of Excel error when saving new files

Many people believe that Excel saving the file with a new name is due to a software error or a computer problem. However, after checking and researching many sources of information. I discovered this error was due to a problem with the Excel file itself. Specifically, this error file was created by an old version of Excel and saved with the .xls extension. If you open the file with new versions of Excel such as 2010, 2016. then the error may appear.

In addition, the error of saving a Word file with a different name or the error of saving a PowerPoint file with a different name may also come from this very cause.

How to fix errors when you cannot oversave Excel files

As mentioned above, if you only use the file a few times. Now you can completely save the file with a new name. But if you have to make multiple edits on the same file, saving with a new name will be very ineffective. In this situation, you can turn off the Use simple file sharing feature on your computer to fix this error. In my opinion, the success rate of this method can be up to 99%. However, when you turn off User simple file sharing, you will no longer be able to share files with other computers on the same LAN.

Instructions to turn off User simple file sharing

1. Step 1 : Press windows + R to activate the Run dialog box. Then enter the command RunDll32.exe shell32.dll,Options_RunDLL 7 and press enter .
2. Step 2 : When the new window appears, select the view tab and uncheck the Use sharing wizard (Reconmender) box .

Instructions on how to fix Excel error of not allowing oversave Picture 5

1. Step 3 : Click Apply to apply the settings and then click ok to save the settings and you're done.

Now when you oversave the Excel file, you will no longer receive the error message. To be more certain, you should close and restart Excel software on your computer. If it still doesn't work, it's best to restart your computer. Then update the software for your computer and reopen Excel.

And above is a summary of the causes and solutions when Excel does not allow overwriting. In case you encounter similar problems on word software or other software in the office suite. You can absolutely apply the measures I have instructed above to quickly fix the error.