Permission & Access Issues

How to Edit Password-Protected Excel Files in Excel for the Web

Khadija KhanKhadija Khan Nov 3, 2026 869 views

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.

How to Edit Password-Protected Excel Files in Excel for the Web
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the workbook in your browser

Navigate to SharePoint or OneDrive in your web browser, click the protected Excel file, and enter the password to open it in Viewing mode.

2
Click Open in Desktop App

Locate the ribbon menu at the top of the browser window. Click the 'Viewing' dropdown or the direct 'Open in Desktop App' button.

3
Authenticate in the desktop application

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.

Use the Open in Desktop App Feature
AutoSave Synchronization: As long as AutoSave is toggled on in the top-left corner of your Excel desktop app, all edits will automatically sync back to the original SharePoint location.
Free Microsoft Office alternative

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.

Fully compatible with Microsoft Excel (.xlsx, .xls) formatsSeamlessly opens, edits, and saves password-protected spreadsheetsFree, lightweight, and fast-loading alternative to MS OfficeFamiliar user interface requiring no steep learning curve
microsoft office alternative - wps office

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.