What is ‘Sharing Violation error’ in Excel in Windows 10?

If you are facing ‘Sharing Violation error in Excel’ issue in Windows 10 when you try to save the modifications you make on Excel table, then you are in right place for the solution. Here, you will be guided with easy steps/methods to resolve the error. Let’s starts the discussion.

‘Sharing Violation error’ in Excel: It is common Windows Problem considered Microsoft Excel error. This error message indicates your change could not be saved to the excel table/file because of sharing violation and urges you try saving to different file. This Excel error is appeared usually when you are unable to save the modifications you make on Excel table/file in your Windows 10 computer. Let’s take a look at error message.

“The file you are trying to open, ‘filename.xls’, is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file .  Do you want to open the file now?”

Or

“Your changes could not be saved to ‘ FileName ‘ because of a sharing violation. Try saving to a different file.”

The possible reason behind this error can be the Excel file that is not permitted to get indexed, sharing wizard is disabled and the interference of third-party antivirus/firewall programs installed in your computer. This Excel error is occurred when the Excel file you are trying to modify, is located inside the folder that is not configured to allow the files inside to get indexed. In such case, you can modify the advanced attributes settings of that particular folder in order to fix the issue.

Another possible reason behind ‘Sharing Violation error’ can be the sharing wizard that is disabled. Excel and most other programs inside Microsoft Office Suite require the sharing Wizard to be enabled in order to work properly. So, you can enable this feature in order to fix the issue. Also,  you can try to fix the issue by disabling your antivirus/firewall program temporarily in computer and check if works for you. Let’s go for the solution.

How to fix Sharing Violation error in Excel in Windows 10?

Method 1: Fix ‘Sharing Violation error’ with ‘PC Repair Tool’

‘PC Repair Tool’ is easy & quick way to find and fix BSOD errors, DLL errors, EXE errors, problems with programs/applications, malware or viruses issues, system files or registry issues, and other system issues with just few clicks.

⇓ Get PC Repair Tool

Method 2: Allow Excel file to get indexed

One possible way to fix the issue is to allow the excel file that was giving ‘Sharing Violation error’ while modifying in it, to get indexed.

Step 1: Close ‘Excel’ app completely and make sure no instances of Microsoft Office suite is running in background. You can close it from ‘Task Manager’

Step 2: Now, right-click on excel file that is causing error, select ‘Properties’

Step 3: In ‘Properties’ window, under ‘General’ tab, go to ‘Attributes’ section and click ‘Advanced’ button

Step 4: In the opened ‘Advanced Attributes’ window, go to ‘Archive and Index Attributes’ and check the ‘Allow files in this folder to have contents indexed in addition to files properties’

Step 5: Finally, hit ‘Apply’ and ‘Ok’ button to save the changes. Once done, open the Excel file again that was giving error and check if the error is resolved.

Method 3: Enable Sharing Wizard

Another possible way to fix the issue is to enable Sharing Wizard that is required for Microsoft Office Suite applications to function properly in computer.

Step 1: Press ‘Windows + R’ keys on keyboard, type ‘control folders’ in ‘Run’ window and hit ‘OK’ button to open ‘Folder Options’

Step 2: In the opened folder, click on ‘View’ tab, scroll down to ‘Advanced Settings’ option until you locate ‘Use Sharing Wizard (Recommended)’ and select this option to check and then hit ‘Apply’ and ‘Ok’ button to save the changes

Method 4: Disable Third-Party Antivirus software/firewall

This issue can also be occurred due to interference of your third-party antivirus/firewall program installed in your computer. It might possible your antivirus software is blocking your from making modifications in Excel file for some security reasons or due to its over security feature. You can disable your third-party antivirus software/firewall temporarily in order to fix the issue. If disabling antivirus didn’t work for you, then you can uninstall your antivirus in order to fix the issue.

Conclusion

I am sure this post helped you on How to fix Sharing Violation error in Excel in Windows 10 with several easy steps/methods. You can read & follow our instructions to do so. That’s all. For any suggestions or queries, please write on comment box below.