Fix Excel error when saving it to keep saving with another name - Knowledge sharing blog

Note: Please read the article carefully before proceeding! If in the process of using you encounter any errors, such as broken download links, slow loading blog, or unable to access a certain page on the blog ... then please inform me through the Contact page. Thanks!

Yes, today I accidentally encountered this extremely annoying error, when a friend sent me an Excel file.

And when I perform a little editing content in that file => then click Save to save it appears a window Save as.. force me to save with a different file name. Which cannot overwrite the old file.

In my case, this error will not be a big problem, because I use that Excel file only a few times.

But imagine how hard it is for someone who has to work with that Excel file every time they save it to start saving a new file.

Even some cases when saved with a different name and then can not open anymore, and it will save with a very awkward character sequence.

Read more:

This is my picture of the error message when I click Save.

excel-file-excel-file-excel (1)

Error notification with the specific content as follows ...

“Your changes could not be saved to“ File-Excel-Name ”because of a sharing violation. Try saving to a different file. ”

#first. Cause of error Your changes could not be saved….

After finding out the cause, I discovered that this Excel file may have been created from an old OFFICE set (possibly created from 2003 OFFICE) - it has the file extension is *.xls

And my computer is using OFFICE 2016, so when I open that Excel file with Excel 2016, my situation is like that ..

#2. Fix the error that the Excel file cannot be saved successfully 100%

Note: You can apply the same if your Word file is not saved as described above, I have not tried it and have never been but I think it is okay.

Yes, with this error, the fix is ​​very simple. You just need to turn off User simple file sharing (Reconmender) on Windows and you're done.

Note: But maybe when you turn this feature off, you won't be able to share files on your computer to other computers on the same LAN anymore.

Perform:

You open Folder Option (for Windows 7) or File Explorer Options (for Windows 8, 8.1 and Windows 10).

How to open it, I have detailed instructions in the previous article, you can read one of the following 2 articles:

Or Quickly follow the instructions below:

Open the Run dialog box (Windows + R) => enter the command below => press Enter is done.

RunDll32.exe shell32.dll, Options_RunDLL 7

Okay, then you uncheck the line User simple file sharing (Reconmender) go => and press Apply is done.

excel-file-excel-file-excel (2)

Now you can try pressing Save on that Excel file see how the result is offline 😀

# 3. Epilogue

So I have very detailed instructions for you how to fix Excel errors when saving to keep saving with another name (Your changes could not be saved to ...).

Hopefully this article will be useful for you, if you have any other ways, please comment and share below this article for you to learn more.

Good luck !

Kien Nguyen - Blogchiasekienthuc.com

Note: Was this article helpful to you? Do not forget to rate the article, like and share it with your friends and relatives!