Fix Excel 2016 Sharing Violations and Read-Only Workbooks
Question details
The user needs to save Excel 2016 workbooks without read-only restrictions or sharing violation errors.

- Product
- Microsoft Excel 2016
- Device & OS
- not provided
- Scenario
- Saving or reopening Excel workbooks when security software may be restricting file changes.
- Observed behavior
- Workbooks open as read-only, and Excel reports that a saved workbook cannot be reopened because of a sharing violation.
Identify the antivirus or ransomware protection software installed on the device and note the folder where the workbook is saved. Menu names may vary by security software version.
Allow Excel in your ransomware protection settings
Use this approach when AVG or Avast may be blocking Excel from modifying protected files.
Open Avast or AVG and go to Protection > Ransomware Shield, or find the ransomware protection settings in your version.
Look for an option such as Blocked & Allowed Apps or Allow an App, then add Microsoft Excel to the allowed list. Follow the security software's instructions to select Excel if prompted.
In the Ransomware Shield settings, review the protected folders or file restrictions. If Excel still cannot save, consider removing the affected folder from protection only if you accept the reduced security.
Return to Excel, open the workbook, and use File > Save As to save it again. Confirm that it reopens without the sharing violation.

Check file access and try another save location
Use these checks if allowing Excel in security software does not resolve the error.
Work with Excel-Compatible Spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for opening and editing Excel-compatible workbooks. It can help you move spreadsheet work to another office suite, but it does not fix Microsoft Excel or security software settings.

Frequently Asked Questions
Why does Excel say there is a sharing violation when my workbook is not shared?
A sharing violation can occur when another process, including security software, interferes with file access. Check your antivirus ransomware protection settings and try allowing Excel.
Where is Ransomware Shield in Avast?
Open Avast and look under Protection > Ransomware Shield. The exact menu names and available controls can vary by version.
Should I remove my Documents folder from ransomware protection?
Removing the folder reduces its protection. First look for an option to allow Excel under Ransomware Shield's blocked and allowed apps settings; remove the folder only if you accept the security trade-off.
What can I do if Excel still opens a workbook as read-only?
Close other copies of the workbook, check its file properties and folder permissions, and try File > Save As in a folder where you can edit files.




