File Sharing Problems

How to Password Protect an Excel File Shared from OneDrive

Maira Mehtab Sep 27, 2026 870 views

Question details

The user wants to password-protect an Excel workbook stored in OneDrive and needs to determine if their personal Microsoft 365 subscription supports password-protected sharing.

Product: Microsoft Excel, OneDrive
Device & OS: not provided
Scenario: Sharing a sensitive Excel file using a secure, password-protected OneDrive link.
Observed behavior: The user is unsure how to protect the file properly and whether their specific Microsoft 365 Personal license includes the premium OneDrive link password feature.

Before you start

Make sure you have the desktop version of Microsoft Excel installed on your computer, as workbook encryption cannot be applied through Excel for the Web.

Solution 1Recommended

Encrypt the Workbook via Excel Desktop

The most reliable way to protect your data is to encrypt the file itself using the Excel desktop app. This works regardless of your OneDrive sharing link settings.

Open the file in Excel Desktop

Launch the Microsoft Excel desktop application and open the workbook you want to protect from your OneDrive folder.

Access the Info menu

Click on the 'File' tab in the top-left corner of the ribbon, then select 'Info' from the left-hand menu.

Apply password encryption

Click on the 'Protect Workbook' dropdown button and select 'Encrypt with Password'.

Set and confirm your password

Type a strong password into the dialog box, click 'OK', re-enter the password to confirm, and click 'OK' again. Save the file to sync the protected version to OneDrive.

Keep your password safe: Microsoft cannot recover forgotten passwords. Ensure you store the workbook password in a secure location.

Solution 2

Use OneDrive Link Password Protection

If you have a qualifying Microsoft 365 subscription, you can add a password directly to the OneDrive sharing link instead of encrypting the file itself.

Secure Your Spreadsheets Easily

Password Protect Spreadsheets for Free with WPS Office

If you are facing restrictions with cloud sharing licenses, WPS Office offers a powerful and free alternative. It provides built-in, robust file encryption that securely protects your spreadsheets before sharing them anywhere.

1. Open the file in WPS Spreadsheet: Launch WPS Office on your computer and open the spreadsheet you wish to secure.
2. Navigate to the encryption settings: Click on the 'Menu' button in the top-left corner, hover over 'File', and select 'File Encryption'.
3. Enter a document password: In the encryption window, type a strong password into the 'Document Password' field and confirm it.
4. Save the encrypted file: Click 'OK' and save the document. You can now safely share the file via any cloud storage or email service.

Seamlessly compatible with Microsoft Excel (.xlsx) formats.Free, lightweight, and easy to use without premium cloud subscriptions.Built-in file encryption to securely protect your sensitive data.Available across Windows, Mac, Linux, Android, and iOS devices.

Frequently Asked Questions

Can I password protect an Excel file using Excel Online?

No, Excel for the Web currently does not support adding or modifying workbook passwords. You must open the file in the desktop version of Excel to encrypt the file itself.

Does a Microsoft 365 Personal subscription support password-protected OneDrive links?

Yes. Microsoft 365 Personal and Family subscriptions both include premium OneDrive features, which allow you to set passwords and expiration dates on your sharing links.

What happens if I forget the password to my encrypted Excel file?

If you forget the workbook encryption password, Microsoft cannot recover or reset it for you. It is highly recommended to keep a secure backup of your passwords in a password manager.

Document & File Issues