File Sharing Problems

Can Multiple Users Edit a Password-Protected Excel File?

Tauseeq Magsi Oct 9, 2026 869 views

Question details

The user wants to know if it is possible for multiple people to simultaneously edit a password-protected Excel workbook.

Can Multiple Users Edit a Password-Protected Excel File?

Product: Microsoft Excel
Device & OS: not provided
Scenario: Sharing a secure, password-protected Excel file with a team for collaborative editing.
Observed behavior: The Excel file locks when the first person opens it, preventing any simultaneous editing or co-authoring by subsequent users.

Before you start

Ensure you know whether your shared Excel file is stored locally, on a network drive, or in the cloud (OneDrive/SharePoint), as this dictates your available collaboration options.

Solution 1Recommended

Understand Excel's Password Protection Limitations

Simultaneous co-authoring is fundamentally unsupported for password-protected Excel workbooks opened in the desktop app.

When a password-protected Excel workbook is opened in the desktop application, it becomes locked by the very first user who accesses it. This effectively prevents simultaneous co-authoring.

Excel co-authoring requires the file to be hosted on supported cloud storage (such as OneDrive or SharePoint) without an 'open document' password. Additionally, there is no reliable owner-controlled command to force-close another user's open desktop file remotely.

Acknowledge the lock prompt

If another user has the password-protected file open, you will receive a 'File in Use' prompt. You must choose to open it as 'Read-Only' to view the contents.

Wait for availability

Click 'Notify' to have Excel alert you when the other user closes the workbook so you can gain write access and make your edits.

Understand Excel's Password Protection Limitations

Cloud Storage Requirement: Excel co-authoring strictly requires supported cloud storage and users signed in with compatible Microsoft accounts.

Solution 2

Remove the Password for Cloud Co-authoring

If simultaneous editing is your priority, you must remove the document password and rely on cloud access permissions instead.

Free Microsoft Office alternative

Collaborate Seamlessly with WPS Office

If you are frustrated by Excel's file locking mechanisms and sharing restrictions, try WPS Office. It provides robust spreadsheet tools, excellent compatibility with Microsoft formats, and a familiar user interface—all for free.

100% compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Free, lightweight, and extremely fast to install.Familiar tabbed user interface makes switching effortless.Built-in cloud tools to share and manage your spreadsheets easily.

microsoft office alternative - wps office

Frequently Asked Questions

Can I remotely close a shared Excel file if someone leaves it open?

No, there is no reliable, owner-controlled command to remotely force-close another user's open Excel file on the desktop app. You must contact the user and ask them to close the file, or wait for their session to time out.

Do users need a Microsoft account to co-author an Excel file?

Generally, yes. Excel co-authoring requires users to be signed in with compatible Microsoft accounts. People without Microsoft accounts cannot simultaneously edit a password-protected workbook.

How do I secure an Excel file without losing co-authoring capabilities?

Instead of using a document open password, store the file in OneDrive or SharePoint. Use the 'Share' feature to grant access only to specific email addresses. This restricts unauthorized access while keeping the file unlocked for simultaneous editing among approved users.