How to Edit Password-Protected Excel Files in Excel for the Web
Question details
The user wants to edit a password-protected Excel workbook stored in SharePoint directly in Excel for the web without having to download the file locally.

- Product
- Microsoft Excel for the Web
- Device & OS
- not provided
- Scenario
- Opening and attempting to edit a password-protected Excel file hosted on SharePoint using a web browser.
- Observed behavior
- After entering the correct password, the Excel workbook only opens in Viewing mode, and editing features are disabled in the web interface.
Verify that you have the correct password to decrypt the workbook and ensure that the Microsoft Excel desktop application is installed on your computer, as web-based editing has specific limitations for encrypted files.
Use the Open in Desktop App Feature
Since Excel for the web cannot edit password-protected workbooks, seamlessly transfer your online session to the full Excel desktop application.
Excel for the web is designed with strict security parameters and currently lacks the ability to edit files protected by passwords. Even if the file is successfully decrypted for viewing in the browser, any modifications must be performed in the desktop software.
SharePoint and OneDrive storage environments do not bypass these encryption limitations. Utilizing the 'Open in Desktop App' feature allows you to edit the file while keeping it synced to the cloud.
Navigate to SharePoint or OneDrive in your web browser, click the protected Excel file, and enter the password to open it in Viewing mode.
Locate the ribbon menu at the top of the browser window. Click the 'Viewing' dropdown or the direct 'Open in Desktop App' button.
Allow your browser to launch Microsoft Excel. You may be prompted to enter the file password one more time. Once opened, you have full editing permissions.

Open the File Directly from Excel Desktop
Bypass the web browser completely by accessing your SharePoint or OneDrive files directly from the Excel desktop interface.
Edit Encrypted Spreadsheets Easily with WPS Office
If you are frustrated by the online viewing restrictions in Microsoft Office or do not have an active Microsoft 365 desktop subscription, WPS Office provides a powerful, free alternative. It seamlessly handles password-protected spreadsheets on your desktop without expensive licensing.

Frequently Asked Questions
Why does my password-protected Excel file open as read-only in the web browser?
Excel for the Web does not support the complex editing features required for encrypted workbooks. To ensure data security and integrity, the web application restricts password-protected files to Viewing mode only.
Can I remove the password using Excel for the Web?
No, you cannot remove or alter a workbook's password within the web browser. You must open the file in the desktop version of Excel, navigate to File > Info > Protect Workbook, remove the password, and save the file back to SharePoint.
Does moving the file to SharePoint fix the online editing issue?
No, storing the file on SharePoint or OneDrive does not change the inherent limitations of Excel for the Web. The encryption restrictions apply regardless of where the cloud file is hosted.
What should I do if I don't have the Excel desktop application installed?
If you lack the Microsoft Excel desktop app, you will not be able to edit the protected file in your browser. You can install a free compatible alternative like WPS Office on your computer to open, edit, and save the password-protected .xlsx file locally.




