• Skip to main content
  • Skip to primary sidebar

Technipages

Tutorials and fixes for smartphone, gadget, and computer problems

  • Topics
    • Android
    • Gaming
    • Hardware
    • Internet
    • iOS
    • MacOS
    • Office
    • Software
    • Windows
    • Definitions
  • Product Reviews
  • Downloads
  • About Technipages
Excel: This File Couldn’t Open in Protected View

Excel: This File Couldn’t Open in Protected View

By Madalina Dinita 2 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…
  • Excel: Force "Open as Read Only" Prompt
    Excel: Force "Open as Read Only" Prompt
  • 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: Fix "File is locked for editing/in use" Errors
    Excel: Fix "File is locked for editing/in use" Errors
  • What is an ARF File and How Do I Open It?
    What is an ARF File and How Do I Open It?
  • What is an EPS File and How to Open It
    What is an EPS File and How to Open It

Filed Under: Software Tagged With: Excel

Reader Interactions

Comments

  1. 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.

  2. 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

  • Windows 11: How to Fix Windows 11 Won’t Connect to a Network
  • What to Do When Firefox Won’t Load a Page
  • Chrome: How to Refresh Various Tabs Simultaneously
  • The Latest Foldable Phones – A Look At The Huawei Mate X2
  • Everything Announced at Google I/O 2022 That You Should Care About
  • How to Build the Best High-Spec PC for Your Budget
  • Google Shows Off Pixel 7 and Pixel Watch Ahead of Fall Launch
  • Windows 11: How to View Saved Passwords

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 2022 Technipages · All Rights Reserved · Privacy