HELP! I can't save any Excel docs because of a "Sharing Violation" message. How do I fix?

%3CLINGO-SUB%20id%3D%22lingo-sub-1421509%22%20slang%3D%22en-US%22%3EHELP!%20I%20can't%20save%20any%20Excel%20docs%20because%20of%20a%20%22Sharing%20Violation%22%20message.%20How%20do%20I%20fix%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1421509%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20is%20a%20consistent%20and%20reoccurring%20problem.%26nbsp%3BI%20had%20hoped%20upgrading%20to%20Office365%20would%20help%2C%20but%20it%20didn't.%20I'm%20the%20Administrator.%20All%20Excel%20workbooks%20were%20created%20by%20me%20and%20I've%20used%20them%20for%20years.%20Some%20are%20.xls%2C%20but%20most%20are%20.xlsx.%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance.%20Any%20and%20all%20suggestions%20are%20greatly%20appreciated.%3C%2FP%3E%3CP%3EMatt%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1421509%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1428833%22%20slang%3D%22en-US%22%3ERe%3A%20HELP!%20I%20can't%20save%20any%20Excel%20docs%20because%20of%20a%20%22Sharing%20Violation%22%20message.%20How%20do%20I%20f%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1428833%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F681282%22%20target%3D%22_blank%22%3E%40matt11653%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWell%2C%20there%20are%20many%20different%20reasons%20responsible%20for%3CSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Ecannot%20save%20Excel%20file%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSTRONG%3Ebecause%20of%20sharing%20violation%3CSTRONG%3E.%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSTRONG%3EHere%20check%20out%20some%20of%20the%20common%20ones%3A%3C%2FP%3E%3CUL%3E%3CLI%3E%3CSTRONG%3EExcel%20file%20is%20not%20allowed%20to%20get%20indexed%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%E2%80%93%20The%20error%20appears%20when%20the%20Excel%20file%20is%20located%20inside%20the%20folder%20that%20is%20not%20permitted%20to%20let%20the%20inside%20files%20to%20get%20indexed.%20%26nbsp%3BAnd%20in%20this%20case%2C%20the%20error%20is%20resolved%20by%20modifying%20the%20particular%20folder%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EAdvanced%20Attributes%20settings%3C%2FSTRONG%3E%3C%2FLI%3E%3CLI%3E%3CSTRONG%3EThe%20Sharing%20Wizard%20is%20Turned%20Off%20%E2%80%93%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSTRONG%3EIn%20Excel%20and%20other%20MS%20Office%20programs%20needs%20the%20Sharing%20Wizard%20option%20enabled%20to%20work%20appropriately.%3C%2FLI%3E%3CLI%3E%3CSTRONG%3EThe%20Third-party%20Antivirus%20controls%20the%20Excel%20file%20%E2%80%93%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSTRONG%3EIt%20is%20found%20due%20to%20the%20third-party%20antivirus%20program%20installed%20on%20the%20users%E2%80%99%20system%20causes%20the%20Excel%20sharing%20violation%20error.%20The%20antivirus%20program%20keeps%20the%20file%20busy%20when%20the%20Excel%20tries%20to%20write%20over%20it.%3C%2FLI%3E%3C%2FUL%3E%3CP%3EDespite%20this%2C%20the%20most%20common%20cause%20responsible%20for%20the%20sharing%20Excel%20files%20sharing%20violation%20error%20is%20when%20you%20frequently%20save%20the%20Excel%20workbook%20at%20the%20very%20short%20interval.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

This is a consistent and reoccurring problem. I had hoped upgrading to Office365 would help, but it didn't. I'm the Administrator. All Excel workbooks were created by me and I've used them for years. Some are .xls, but most are .xlsx. 

Thank you in advance. Any and all suggestions are greatly appreciated.

Matt

1 Reply
Highlighted

Hi @matt11653 

 

Well, there are many different reasons responsible for cannot save Excel file because of sharing violation. Here check out some of the common ones:

  • Excel file is not allowed to get indexed – The error appears when the Excel file is located inside the folder that is not permitted to let the inside files to get indexed.  And in this case, the error is resolved by modifying the particular folder Advanced Attributes settings
  • The Sharing Wizard is Turned Off – In Excel and other MS Office programs needs the Sharing Wizard option enabled to work appropriately.
  • The Third-party Antivirus controls the Excel file – It is found due to the third-party antivirus program installed on the users’ system causes the Excel sharing violation error. The antivirus program keeps the file busy when the Excel tries to write over it.

Despite this, the most common cause responsible for the sharing Excel files sharing violation error is when you frequently save the Excel workbook at the very short interval.