How to Fix Excel Email Attachments Opening as Read-Only
Question details
Users are unable to edit Excel files received via email because the spreadsheets automatically open in Protected View or read-only mode.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Opening an Excel spreadsheet attachment downloaded from an email client.
- Observed behavior
- The Excel file opens in read-only mode or Protected View due to security settings, preventing immediate editing.
Ensure that the email sender is trusted and the attachment is safe to open before disabling Protected View or unblocking the file.
Save and Unblock the File via Properties
Saving the file locally and unblocking it in Windows is the safest and most effective way to gain edit access without compromising system security.
Windows tags files downloaded from the internet or email clients as potentially unsafe. Unblocking the file individually ensures you only allow access to files you explicitly trust.
Download the Excel attachment from your email and save it to a local folder on your computer, such as your Desktop or Documents folder.
Right-click the downloaded Excel file and select "Properties" from the context menu.
In the General tab, look for a Security section at the bottom. Check the box that says "Unblock" and click "Apply" followed by "OK".
Double-click the file to open it in Excel. It should now open normally without the read-only restriction.

Enable Editing from Protected View
Use the built-in Protected View banner to temporarily enable editing for a specific file directly within Excel.
Adjust Trust Center Settings (For Advanced Users)
Modify Excel's Trust Center settings to stop opening email attachments in Protected View. This should only be done by or with permission from an IT administrator.
Open and Edit Email Attachments Easily with WPS Office
If strict security settings are slowing down your workflow, consider switching to WPS Office. It provides a lightweight, highly compatible, and user-friendly experience for managing spreadsheets safely without unnecessary hurdles.
- 1. Download WPS Office: Visit the official WPS website and download the free WPS Office suite for your operating system.
- 2. Set as Default Application: Install the software and set WPS Spreadsheet as your default program for opening Excel file formats.
- 3. Open Attachments Seamlessly: Double-click any spreadsheet attachment in your email to open it instantly in WPS Office, ready for editing.

Frequently Asked Questions
Why do my Excel files always open in read-only mode from emails?
Microsoft Office uses a security feature called Protected View. It automatically treats files downloaded from the internet or received as email attachments as potentially unsafe, opening them in read-only mode to prevent malicious scripts from running automatically.
Can I permanently disable the read-only mode for all email attachments?
Yes, you can disable this by navigating to Excel's Trust Center > Trust Center Settings > Protected View, and unchecking the options for internet files and Outlook attachments. However, this is heavily discouraged as it leaves your computer vulnerable to malware.
Does saving the file to a specific folder fix the read-only issue?
Yes. Saving the file to a designated Trusted Location set in your Excel Trust Center settings will bypass Protected View and allow you to open the file in edit mode directly.




