Please also refer to "Change permissions for files, folders, or disks on Mac", make sure you have read & write permission for these files. (Please Note: Since the web site is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.) Show
Besides, I suggest you try to move one file to other location to check this issue. Any updtes, you may post back. If an Answer is helpful, please click "Accept Answer" and upvote it. Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread. Getting a “Sharing Violation” error while trying to save a Microsoft Excel spreadsheet on your computer? You may not have the required permissions to save the file in your folder. There are other causes of this issue, and we’ll show you how to resolve all those items to let you save your file successfully. Other reasons you can’t save changes to your MS Excel file are that your antivirus program is interfering with your file, file content indexing is disabled for your spreadsheet folder, the Excel app itself has problems, and more. New york, USA – August 18, 2017: Microsoft excel menu on laptop screen close-upGet the Required Permissions for Your Network FolderIf you’re getting the “Sharing Violation” error while trying to save your spreadsheet on a network drive, ensure you have the correct permissions to do so. You need both Modify and Delete privileges to save files on your network folder. Since you don’t have the required permissions, ask your network administrator to grant you both of the above permissions. Once the admin has done that, you’ll be able to save your file at your desired network location. Turn On the Sharing Wizard in Windows File ExplorerAnother reason you get a “Sharing Violation” error is that you don’t have Sharing Wizard enabled in your File Explorer app. It’s worth toggling on this feature on your Windows PC to get rid of your error.
Save Your Excel Spreadsheet on Your Local StorageOne way to fix your Excel error is by saving your spreadsheet to your computer’s local storage. This helps you bypass any network-related issues and save your file successfully. You can then manually transfer the file to your network drive if you wish.
Depending on how you’ve connected your computer to your network, you can use your machine’s file manager app to copy your saved Excel file and paste it on your network folder. Save Your Excel File With a New NameIf you still have trouble saving your Excel file, use a different name for your file and try to save the file. This will help you resolve any name-related conflicts, allowing you to save your file without issues.
Turn Off Your Antivirus ProgramOne possible reason you get a “Sharing Violation” error is that your antivirus program has blocked your access to your file. Sometimes, antivirus programs produce false-positive results, leading to various errors. In this scenario, temporarily disable your antivirus program and see if you can then save your file. You can turn your antivirus back on when you’ve saved the file. How you turn off your antivirus protection depends on the program you’re using. You can follow the following instructions to disable Microsoft Defender Antivirus:
If the above has fixed your issue, reach out to your antivirus provider to seek a permanent solution to the problem. Turn On Indexing for Your Spreadsheet FolderYou can turn on one Windows option to potentially fix your Excel “Sharing Violation” error. This option indexes the contents of the files in your folder in addition to your files’ properties.
Repair Your Microsoft Excel AppIf your error message hasn’t gone away yet, your last resort is to fix the Microsoft Excel app itself. The app may be experiencing issues, producing various kinds of errors. Luckily, you don’t have to do much to repair your app. Microsoft Office includes a repair tool that allows you to fix all your Office apps in a few easy clicks. You can use this tool to fix all the issues that your Excel app is experiencing.
Multiple Ways to Get Around Excel’s Sharing Violation ErrorMicrosoft Excel displays the above error message for various reasons. Once you fix the items that may potentially be causing the problem, you can resolve your error and save your Excel spreadsheet at the desired location. We hope the guide helps you save changes to your Excel files. |