• Skip to main content
  • Skip to primary sidebar

Technipages

Tutorials and fixes for smartphone, gadget, and computer problems

  • Topics
    • Android
    • Browsers
    • Gaming
    • Hardware
    • Internet
    • iPhone
    • Linux
    • macOS
    • Office
    • Reviews
    • Software
    • Windows
    • Definitions
  • Product Reviews
  • Downloads
  • About
Excel: This File Couldn’t Open in Protected View

Excel: This File Couldn’t Open in Protected View

December 17, 2020 by Madalina Dinita 3 Comments

Excel Protected View is a mode that allows users to open files while disabling most editing features.

If you cannot open an Excel file in Protected View, there’s reasonable evidence to indicate the file is coming from an unsafe location. Or that it could be malware-ridden. In order to protect your computer, Excel decided not to open that file.

But there are situations when Protected View doesn’t open files coming from safe locations. As a result, Excel freezes, and users need to force-close the program.

Excel Protected View Won’t Open Files

Disable Protected View

But do this only if you’re absolutely sure that the file you want to open is safe.

  1. Launch Excel and click on the File tab.
  2. Then go to Options and select Trust Center.
  3. Select Protected View.excel protected view settings
  4. Untick the checkbox appropriate for your situation:
    1. Enable Protected View for files originating from the Internet.
    2. Or Enable Protected View for files located in potentially unsafe locations.
    3. The third option lets you Enable Protected View for Outlook attachments.

For example, if the file you’re trying to open in Protected View comes from an Outlook attachment, untick the last option.

Repair Office

If this is a false-positive alert, it could be due to corrupted Office files. Repair Office to solve the problem.

  1. Launch Control Panel.
  2. Then go to Programs and Features.
  3. Select Office 365/Microsoft 365.microsoft office 365 change control panel
  4. Click on theChangebutton.
  5. Select Quick Repair. And if that does not help, select Online Repair.

quick repair office windows 10

Download and Rename the File

The troubleshooting suggestions below come from Excel users who encountered the same issue. These methods may not work for all users. But it’s worth giving these suggestions a try.

Some users managed to bypass this issue by downloading the problematic file on their computers. After that, they renamed it and were able to open it in Protected View.

Sometimes, you may also need to convert the file to a newer Excel format. Many users could not open Excel 97- Excel 2003 Workbook format (.xls) files using the latest Excel version.

change excel file type

A third workaround involves opening a blank Excel document. Then place the problematic file into the new blank file. Save the new file using a different file name. And open it just as you would open a normal file.

Test all these suggestions. See which method works for you.

You Might Also Like

  • What Does 'Protected View' Mean?
    What Does 'Protected View' Mean?
  • Fix OneNote Error: We Couldn't Open That Location
    Fix OneNote Error: We Couldn't Open That Location
  • Windows 10: How to Check if a Video or Music File is DRM Protected
    Windows 10: How to Check if a Video or Music File is DRM…
  • OneDrive: We Couldn't Merge The Changes in Office File
    OneDrive: We Couldn't Merge The Changes in Office File
  • Fix: Google Drive Couldn’t Preview File
    Fix: Google Drive Couldn’t Preview File
  • Excel: Force "Open as Read Only" Prompt
    Excel: Force "Open as Read Only" Prompt

Filed Under: Software Tagged With: Excel

Reader Interactions

Comments

  1. JohnnyC says

    July 2, 2022 at 6:17 pm

    It does not always mean the file, it can also mean an error within Excel. I am experiencing this issue when just firing up Excel. One can click past the error but it happens when just opening the program and not even a file.

    Tried the quick repair and also the online repair, and still the same issue.

  2. Keep says

    April 25, 2021 at 4:41 pm

    Hello,
    Why would be the reason this VBA code not working? I have an .xlsm file with a VBA code for my needs, All sheets are unlocked. The cell with drop-down is on one sheet. The validation list is on the other sheet.
    When trying to select a second item from the drop-down, the cell value just changes entirely to that list item instead of adding it after comma.

  3. karmen says

    December 18, 2020 at 12:58 pm

    instant help

Did this help? Let us know!

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Recent Posts

  • How to Print Labels from Excel Using MS Word Mail Merge
  • What Is NVMe Over TCP (NVMe/TCP)
  • Android Mobile Hotspot: How to Change the Password and Name
  • Windows 10: How to Force Quit and App
  • What is Dumpster Diving?
  • How to Download iOS 16 Beta 3 on iPhone or iPad
  • What is a Security Compromise?
  • Mastodon: How to DM Someone

Who’s Behind Technipages?

Baby and Daddy My name is Mitch Bartlett. I've been working in technology for over 20 years in a wide range of tech jobs from Tech Support to Software Testing. I started this site as a technical guide for myself and it has grown into what I hope is a useful reference for all.

You May Also Like

  • Protected Mode
  • Open Standard
  • Open Source Software (OSS)
  • Encapsulated Postscript (EPS) File
  • File Compression Utility

© Copyright 2023 Guiding Tech Media · All Rights Reserved · Privacy