How To Fix The Sharing Violation Error in MS Excel

In this tutorial, we will show you how to fix the Sharing Violation Error in Excel. This spreadsheet app from Microsoft seems to be giving a tough time to a...

Syed Sadique Hassan

Last updated on September 4, 2023

Syed Sadique Hassan

Author

Did his MBA from Delhi but then something about the Android ecosystem intrigued him so much that he made Tech Blogging his permanent job. And now there's no looking back.

In this tutorial, we will show you how to fix the Sharing Violation Error in Excel. This spreadsheet app from Microsoft seems to be giving a tough time to a few of its users. When they are trying to save their data in their Excel spreadsheet, they are being greeted with a violation error. The complete error message reads as: “Your changes could not be saved to ‘FileName’ because of a sharing violation. Try Saving to a different file.”

As to the reasons for this error, it could be due to authorization issues with the indexing of the folder that holds the concerned Excel file. Likewise, if the Sharing Wizard is disabled, then the above-mentioned error might pop up as well. Along the same lines, a third-party antivirus or firewall app might also conflict with the saving of this Excel file. In this guide, we will list out the steps to fix these issues which will then fix the Sharing Violation Error in Excel as well.

Fix 1: Index the Folder having the Excel file

if the File Indexing of the folder that has your concerned Excel file isn’t authorized, then there is every chance of getting the violation error message. With that said, here are the required steps to carry out the indexing process.

Head over to the folder where that spreadsheet file is located, right-click on it, and select Properties.
Then go to the General tab and click on Advanced.
Under the Advanced Attribute dialog box, go to the Archive and Index attributes section.
Finally, tick-mark the Allow files in this folder to have contents indexed in addition to file Properties option.
Click Apply followed by OK. Now try saving the Excel file and check if the Sharing Violation Error has been fixed or not.

Fix 2: Save it to a Different Location

So even after indexing the directory, you are getting a violation error, then probably you should try saving that Excel file to a different location. Well, even the error message reads out as “Try Saving to a different file”. So let’s make full use of this tip. Furthermore, it is also recommended that you save it with a different name. Here is how it could be done:

Open that Excel file and click on File from the top menu bar.
Then select the Save As option from the left menu bar.
Select a different location than where the file is currently saved.
Also, give it a different name and hit the Save button.

Now launch the file and see if Sharing Violation Error in Excel has been fixed.

If the Sharing Wizard settings of the folders on your PC is disabled, then Excel might throw up the violation issues. So the best route forward is to enable this feature right away.

To do so, launch the Run dialog box using the Windows+R shortcut key combinations.
Now type in “control folders” in the box and hit Enter. This will bring up the File Explorer options.
Go to the View tab and make sure that the Use Sharing Wizard (Recommended) option is enabled.
If it’s not, then select that option and click on Apply > OK.
Try saving that Excel file and check whether the Sharing Violation Error in Excel has been rectified or not.