'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Excel Files Opening in Protected View from SharePoint
Question details
Users are unable to edit SharePoint-hosted Excel files because they intermittently open in Protected View or read-only mode.
- Product
- Microsoft Excel, SharePoint
- Device & OS
- not provided
- Scenario
- Opening and attempting to edit Excel spreadsheets hosted on Microsoft SharePoint.
- Observed behavior
- The Excel files frequently launch in Protected View or read-only mode, blocking the user's ability to modify the document content.
Verify that no other user currently has the file open without co-authoring enabled, as SharePoint will automatically lock the document and force subsequent users into read-only mode.
Check Document Protection Settings in Excel
Confirm that the Excel file is not manually set to read-only or protected by built-in security settings.
Often, files open in read-only mode because a user previously applied workbook protection, or the file was marked as final. Checking the native Info panel allows you to quickly remove these restrictions.
Launch the Excel desktop application and open the SharePoint-hosted file that is exhibiting the issue.
Click on the 'File' tab in the top-left corner of the Excel ribbon, then select 'Info' from the left-hand menu.
Look at the 'Protect Workbook' section. Check if the file is restricted, protected with a password, or marked as final.
If the workbook is protected, click the 'Protect Workbook' dropdown and deselect the active protection methods to enable editing.
Open the File Directly from the Excel Desktop App
Bypass potential browser or sync client issues by opening the file directly from within Excel's built-in SharePoint browser.
Contact Microsoft 365 Administrator for Backend Investigation
If the issue is intermittent and persists across multiple files, server-side logs may be required to resolve stuck file locks.
Try WPS Office for Seamless and Free Spreadsheet Editing
If you are experiencing continuous sync, permission, or licensing issues with Microsoft Office, consider switching to WPS Office. It provides a lightweight, highly compatible alternative for managing your spreadsheets, documents, and presentations for free.
- 1. Download and Install: Visit the official WPS website, download the free installer, and complete the quick installation.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheet and easily open any existing .xlsx files without worrying about formatting loss.
- 3. Edit Without Restrictions: Enjoy a smooth, lock-free editing experience on your local machine.
Frequently Asked Questions
Why do Excel files from SharePoint open in Protected View?
Protected View is a security feature in Microsoft Excel. Files originating from internet locations, including SharePoint and OneDrive, are sometimes flagged as potentially unsafe and opened in this restricted mode to prevent malicious macros or scripts from executing.
How can I permanently trust a SharePoint site in Excel?
You can add the SharePoint URL to your Trusted Sites in Windows Internet Options. Additionally, in Excel, go to File > Options > Trust Center > Trust Center Settings > Trusted Locations, and check the box to 'Allow Trusted Locations on my network', then add the specific SharePoint path.
Can improper co-authoring cause a file to become read-only?
Yes. If another user has the file open in a version of Excel that does not support co-authoring, or if someone's previous session crashed without closing the file properly, SharePoint will lock the file to prevent version conflicts, forcing you into read-only mode.
Does WPS Office support opening Microsoft Excel files?
Absolutely. WPS Spreadsheet is fully compatible with Microsoft Excel file formats, ensuring your data, complex formulas, and formatting remain completely intact when you switch.
