Save your files wherever you want
How to Solve Division Violation Problem in Excel | 2 Methods | AstroDynamo
Are you getting a "Sharing Violation" error message while trying to save a Microsoft Excel spreadsheet on your computer? You may not have the required permissions to save the file to your folder. There are other causes for this problem and we will show you how to fix all of them to successfully save your file.
Other reasons why you can't save changes to your MS Excel file include your antivirus program interfering with your file, file content indexing being disabled for your spreadsheet folder, issues with the Excel app itself, and more.
If you get a "Sharing Violation" error while trying to save your spreadsheet to a network drive, make sure you have the correct permissions to do so. You will need both Modify and Delete permissions to save files to your network folder.