'%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)
Fix Excel for the Web Cannot Format Cells in SharePoint
Question details
The user is unable to format cells in an Excel workbook opened from SharePoint via Excel for the Web, as the file opens in protected mode with disabled formatting and limited co-authoring.
- Product
- Excel for the Web, SharePoint
- Device & OS
- not provided
- Scenario
- Editing an Excel workbook online via SharePoint and attempting to format cells or use co-authoring features.
- Observed behavior
- The workbook displays in protected mode, formatting options are disabled, only one browser editor is allowed at a time, and the file may report as being locked.
Ensure you have a stable internet connection and verify that you have 'Edit' permissions for the specific file in the SharePoint document library.
Recreate the Excel Workbook
If only a single file is affected and continues to behave poorly, the workbook may be corrupted. Recreating it is the most practical and effective workaround.
When an individual Excel file experiences persistent protected mode restrictions and file-locking issues on SharePoint, it often indicates underlying file corruption or unsupported legacy formatting that cannot be resolved through standard browser settings.
Navigate to your SharePoint document library, select the affected Excel workbook, and click 'Download' to save a local copy to your computer.
Open the Excel desktop application and create a completely new, blank workbook.
Open the downloaded file, copy your data, and paste it into the new blank workbook. It is highly recommended to use 'Paste Special' > 'Values' to avoid bringing over corrupted formatting.
Save the new workbook as a modern .xlsx file with a different name. Upload this new file back to the SharePoint site and open it in Excel for the Web to verify that formatting and co-authoring now function correctly.
Diagnose Scope and Check Co-Authoring Settings
Determine if the issue is isolated to one file or a broader SharePoint site problem, and verify Microsoft's co-authoring requirements.
Try WPS Office for Seamless Spreadsheet Editing
If you are experiencing persistent file-locking or formatting issues with Excel on SharePoint, consider switching to WPS Office. It provides a lightweight, highly compatible, and free alternative to Microsoft Office, ensuring you can edit and format your spreadsheets locally or via cloud without unnecessary protected mode restrictions.
- 1. Download WPS Office: Visit the official WPS Office website and download the free installation package for your device.
- 2. Install and launch: Run the installer, follow the on-screen prompts, and launch WPS Spreadsheets.
- 3. Open and edit your file: Click 'Open' to locate your .xlsx file and begin editing and formatting immediately without browser-based protected mode limitations.
Frequently Asked Questions
Why does my Excel file open in protected mode on SharePoint?
Excel for the Web may open a file in protected mode if it detects unsupported features, potential file corruption, or if strict SharePoint security policies restrict browser editing for certain file types.
How do I fix the 'file locked' error in Excel for the Web?
A file is often locked if another user has it open in the desktop app without co-authoring enabled, or if a previous session did not close properly. You can resolve this by asking the user to close the file or waiting 10-15 minutes for the server session to time out.
Can I force SharePoint to allow formatting in my Excel workbook?
If formatting is disabled, first check if the worksheet is protected by navigating to the 'Review' tab and selecting 'Unprotect Sheet'. If the file itself is corrupted and limiting features, you will need to copy its contents into a brand new workbook.
Why is co-authoring limited to one browser editor at a time?
This usually happens if the workbook contains features not supported by Excel for the Web co-authoring, such as legacy macros, strict data validation, or if it is saved in an older format like .xls instead of the modern .xlsx format.
