Sharing Violation Excel Error. In this article, you will read what causes Excel sharing violation error and how to fix sharing violation Excel error. Many Excel users report this type of error. They are unable to change anything in the Excel sheets uploaded to File servers. Whenever they try to make the changes, this error pops up. Here, we will discuss how to troubleshoot sharing violation Excel error.
What Causes The Excel Sharing Violation Error?
Some of the reasons that can trigger this issue are:
-Excel files are not getting indexed.
-Sharing wizard is disabled.
-Any 3rd party app like Antivirus is preventing Excel from sharing.
How To Fix Sharing Violation Excel Error?
Method 1 – Enable Indexing For The Excel File:
The most common cause of this error is when the Excel files do not have permission for getting indexed. This is because the directory file is not allowing the files to get indexed. So, you have to enable indexing in the directory the Excel folder resides. To do so:
1.Keep Excel closed and prevent any other MS Office applications from running in the background.
2.Use the Task Manager to close the applications.
3.Press Ctrl + Shift + Esc keys to open the Task Manager.
4.Select the Processes tab.
5.Right-click on the MS Office applications that are running in the background.
6.Click on the End Task option to close the applications.
7.After this, navigate to the directory where the Excel file is stored.
8.Right-click on the directory that holds the Excel file.
9.Select the Properties option.
10.In the Properties prompt, select the General tab.
11.Click on the Advanced option in the Attributes section.
12.In the Advanced Attributes prompt, check the ‘Allow files in this folder to have contents indexed in addition to file Properties’ box in the Archive and Index attributes section.
13.Click on OK to save the changes in the Advanced Attributes window.
14.Click on Apply and OK to save the changes.
15.Close the Properties window.
Check, if you can’t save Excel file, then try out the next method.
Method 2 – Enable The Sharing Wizard:
It is very important for the MS office that sharing wizard should work properly. If the sharing wizard will be disabled then, the Excel sharing violation error can appear. To enable the sharing wizard, follow the steps given below:
1.Press the Windows + R keys to open the Run utility.
2.Type control folders in the search box.
3.Press Enter to open the File Explorer Options prompt.
4.Click on the View tab and in the Advanced settings scroll down.
5.Locate the Use Sharing Wizard (Recommended) box.
6.Check the Use Sharing Wizard (Recommended) box.
7.Click on Apply and OK to save the changes.
8.Restart your PC.
Method 3 – Disable 3rd Party Antiviruses:
Antivirus plays a vital role in keeping your system safe, but sometimes they become overprotective and start interfering with the other programs. It can be possible that Excel sharing violation error is caused by the installed antivirus of your PC. Try to disable the antivirus, to do so:
1.Press the Windows + I keys to open the Settings app.
2.Click on the Update and Security option.
3.Select the Windows Security option.
4.Click on the Virus and Threat protection option in the Protection areas section.
5.Select the Manage settings option in the Virus & threat protection settings section.
6.Turn off the Real-time protection This will disable the Windows Security.
After disabling the antivirus, check if the problem is solved or not. If not then you have to uninstall the antivirus. To uninstall the antivirus:
1.Press the Windows + R keys to open the Run utility.
2.Type appwiz.cpl.
3.Press Enter to open the Programs and Features window.
4.Locate the antivirus among the other apps and right-click on it.
5.Selected the Uninstall option.
6.Follow the on-screen instructions to complete the process.
7.Restart your PC.
Method 4 – Try Saving The File In ANother Directory:
If you have tried all the above-mentioned methods and none of them has worked, try to save the file somewhere else. To save the file in another directory:
1.Open the Excel file that you can’t save.
2.Make your changes.
3.Click on the File option.
4.Select the Save As option.
5.Browse to another folder.
6.Change the name if you want to.
7.Click on the Save option.
If saving the file in another directory doesn’t work, then try to save the changes in the new Excel file. If this solution works, then keep using it and delete the old Excel file.
featured image source: techrepublic.com