Permission & Access Issues

Fix Excel 2016 Sharing Violations and Read-Only Workbooks

Jason MillerJason Miller Nov 20, 2026 869 views

Question details

The user needs to save Excel 2016 workbooks without read-only restrictions or sharing violation errors.

Fix Sharing Violations and Read-Only Workbooks in Excel 2016
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.
Before you start

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.

Solution 1Recommended

Allow Excel in your ransomware protection settings

Use this approach when AVG or Avast may be blocking Excel from modifying protected files.

1
Open ransomware protection

Open Avast or AVG and go to Protection > Ransomware Shield, or find the ransomware protection settings in your version.

2
Allow Excel

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.

3
Check protected folders if needed

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.

4
Test the workbook

Return to Excel, open the workbook, and use File > Save As to save it again. Confirm that it reopens without the sharing violation.

Allow Excel in your ransomware protection settings
Keep protection enabled: Allowing Excel is generally preferable to disabling shields or removing a folder from protection. If you temporarily changed protection settings while testing, re-enable them afterward.
Free Microsoft Office alternative

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.

Open and edit Microsoft Excel XLS and XLSX filesUse familiar spreadsheet tools for everyday workbook tasksMove existing spreadsheets to a lightweight office suiteUse WPS Office for free
QA img-9

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.