How to Fix Excel XLS Files That Will Not Open in Protected View
Question details
The user is unable to open older Excel XLS files because they are being blocked by the application's Protected View security feature.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to open an older XLS format workbook downloaded from the internet or received as an Outlook email attachment.
- Observed behavior
- The XLS workbook fails to open as it gets restricted and blocked by Excel's Protected View or File Block settings.
Ensure that the XLS file comes from a trusted and verifiable source before modifying any security settings. Bypassing Protected View can expose your computer to malicious software if the downloaded file or attachment is unsafe.
Adjust Trust Center Settings to Bypass Protected View
Temporarily disable Protected View for internet files and Outlook attachments to allow the trusted XLS workbook to open.
By default, Excel opens files from potentially unsafe locations in Protected View. If you trust the source of the XLS file, you can temporarily change these security settings in the Trust Center.
Launch Microsoft Excel, click on the 'File' tab in the top-left corner of the ribbon, and select 'Options' from the bottom of the menu.
In the Excel Options dialog box, select 'Trust Center' from the left-hand navigation pane, then click the 'Trust Center Settings...' button on the right.
Navigate to 'Protected View' in the left menu. Uncheck the boxes for 'Enable Protected View for files originating from the internet' and 'Enable Protected View for Outlook attachments'.
Click 'OK' to apply the changes, then navigate to your XLS file and try opening it again.
Modify File Block Settings for Older Formats
If adjusting Protected View doesn't work, Excel might be explicitly blocking older XLS (Excel 97-2003) file types from opening.
Easily Open Older XLS Files with WPS Office
If Microsoft Excel continues to block your older files with complex Protected View settings, consider using WPS Office. It is a free, lightweight office suite that seamlessly opens outdated Microsoft Office formats like XLS without repetitive security blockades, offering you a familiar UI and zero learning curve.
- 1. Download WPS Office: Download and install the free version of WPS Office from the official website.
- 2. Open WPS Spreadsheet: Launch the WPS Spreadsheet application on your computer.
- 3. Open the XLS File: Click 'Open' to browse for your older XLS file, or simply drag and drop the file directly into the application window to view and edit it immediately.
Frequently Asked Questions
Why does Excel open downloaded files in Protected View?
Excel opens files in Protected View to act as a security sandbox. This protects your computer from potentially harmful macros, viruses, or malware that are commonly hidden in files downloaded from the internet or received as unknown email attachments.
Is it safe to permanently disable Protected View in Excel?
It is generally not recommended to permanently disable Protected View. You should only temporarily clear these security settings when you need to open a specific legacy file from a highly trusted source, and you should re-enable the settings immediately afterward to keep your system safe.
What is the difference between Protected View and File Block Settings?
Protected View opens a file in a restricted, read-only mode to let you view potentially unsafe content without risking your system. File Block Settings, on the other hand, completely prevent Excel from opening or saving specific, often outdated file types (like Excel 97-2003 workbooks) at the application level.
