Fix Excel Workbooks Opening as Read-Only in Windows 10
Question details
The user needs to save changes to Excel workbooks that open as read-only or cannot be saved.

- Product
- Microsoft Excel
- Device & OS
- Windows 10
- Scenario
- Editing and saving an Excel workbook on a Windows 10 computer.
- Observed behavior
- The workbook opens as read-only or changes cannot be saved; antivirus ransomware protection may be blocking Excel.
Identify which antivirus application is active and note the workbook's folder. Check whether the issue affects one workbook or files in a protected folder more broadly.
Allow Excel through ransomware protection
Use this solution when antivirus protected-folder settings are blocking Excel from saving files.
Open Start > Settings > Update & Security > Windows Security > Virus & threat protection. Select Protection history and look for an entry showing that Excel was blocked.
Under Virus & threat protection, select Manage ransomware protection. If you use another antivirus application, open its ransomware protection or protected-folder settings instead.
If Controlled folder access blocked Excel, select Allow an app through Controlled folder access > Add an allowed app. Choose Excel from recently blocked apps or browse to the trusted EXCEL.EXE file. In another antivirus application, remove Excel from its blocked-app list or add it to its allowed-app list.
Close and reopen Excel, open the affected workbook, and use File > Save to test whether changes can be saved.

Check the workbook's read-only attribute
Use this check if the issue affects a particular local workbook rather than all files in a protected folder.
Edit Excel-Compatible Workbooks with WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for common Excel formats, making it easy to move existing workbooks. It does not change antivirus or folder permissions, so those restrictions must still be resolved.

Frequently Asked Questions
Why can Excel open a workbook but not save it?
Ransomware protection may allow Excel to read a file but block it from changing files in a protected folder. Check Windows Security > Virus & threat protection > Protection history for a blocked Excel entry.
Where can I allow Excel through Controlled folder access?
Open Windows Security > Virus & threat protection > Manage ransomware protection, then select Allow an app through Controlled folder access > Add an allowed app. Allow only a trusted copy of Excel.
What if only one workbook opens as read-only?
In File Explorer, right-click the workbook and select Properties. On the General tab, clear Read-only if selected, then reopen the file. Also check whether you have permission to edit its folder.
Will switching to WPS Office bypass ransomware protection?
No. Ransomware protection can also block other spreadsheet applications. If a trusted application is blocked, review the antivirus protection history and allow it through the appropriate settings.




