Can not open in Protected View?

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.

How do you fix Cannot open in Protected View Excel?


  1. In the File tab, click Options.
  2. In the Excel Options dialog box, click Trust Center.
  3. Click Trust Center Settings.
  4. Click Protect View.
  5. In the Trust Center dialog box, clear the following check boxes as appropriate for your situation: Enable Protected View for files originating from the Internet.

How do I turn off Protected View in open?

To disable Protected View in Excel: Go to File > Options. Select Trust Center > Trust Center Settings > Protected View. Clear the box for Enable Protected View for files originating from the internet.

IT IS INTERESTING:  Why AES is most secure block cipher algorithm?

Why is my Excel file opening in Protected View?

Overview. By default, Excel activates certain “protected view” settings. This is meant to prevent you from opening an potentially infected file downloaded from the Internet, sent to you in an Email, etc. The reality, however, is that it typically ADDS an additional step to opening many Excel files that you receive.

How can you unprotect an Excel spreadsheet?

Unprotect an Excel worksheet

  1. Go to the worksheet you want to unprotect.
  2. Go to File > Info > Protect > Unprotect Sheet, or from the Review tab > Changes > Unprotect Sheet.
  3. If the sheet is protected with a password, then enter the password in the Unprotect Sheet dialog box and click OK.

Why does Word open in Protected View?

Files from the Internet and other potentially unsafe sources can contain viruses or malware that can harm your computer or compromise sensitive data. To reduce the risk of malware attacks from Internet files, Word opens the document in Protected View. This way you can view the document while reducing the risk.

How do I remove Protected View in Excel without password?

Just do any of the following:

  1. Right-click the sheet tab, and select Unprotect Sheet… from the context menu.
  2. On the Review tab, in the Changes group, click Unprotect Sheet.
  3. On the Home tab, in the Cells group, click Format, and select Unprotect Sheet from the drop-down menu.

How do you remove password protection from Excel 2010?

Step 1: Open the file containing the password that you want to remove in Excel 2010.

  1. Step 2: Click the Review tab at the top of the window.
  2. Step 3: Click the Unprotect Sheet button in the Changes section of the navigational ribbon.
  3. Step 4: Type the password into the Password field, then click the OK button.
IT IS INTERESTING:  Does it take a long time to uninstall McAfee?

How do I change a Word document from Protected View?

Enable editing in your document

  1. Go to File > Info.
  2. Select Protect document.
  3. Select Enable Editing.

How do I remove Protected View in Word without password?

Press Alt+F11 again to close the VBA editor, click on the protected text to open the Restrict Editing menu. Click Stop Protection. It will stop protection without the password.

How do I unprotect an Excel workbook online?

Step 1: Open the worksheet you want to unprotect. Step 2: Click on File > Info > Unprotect Sheet. Step 3: Or go to Review Tab > Changes > Unprotect Sheet.

How do I unlock a file for editing?

Right-click on the file. In the menu that appears, select Lock File. To unlock, right-click the file and select Unlock File.

Why is Word locked on my computer?

Why does my Microsoft Word say the selection is locked? The most common cause of the ‘Selection is locked error’ is due to an unactivated version of Office, and the document is protected or restricted from editing in some ways.

How do I unlock a locked folder?

Right-click the folder to lock and choose Lock Folders. The folder and all subfolders are locked. 2. To unlock a folder, right-click a locked folder and choose Unlock Folders .

What does you can’t make this change because the selection is locked?

The problem: When you edit a Word document, you receive a warning message stating the selection is locked: “You can’t make this change because this selection is locked.” This message can be triggered by these issues: 1. Your Office is not activated or you are using a trial version of Office that has expired.

IT IS INTERESTING:  How many seasons does Port Protection have?

How do I turn off lock on Windows 10?

Release a File Lock in Windows

  1. Hold the Windows Key and press “R” to bring up the Windows Run dialog screen.
  2. Type “mmc“, then press “Enter“.
  3. Go to “File” > “Add/Remove Snap-in…“.
  4. Scroll down and select “Shared Folders“, then choose “Add“.

How do I install Office 365 for free?

Sign in to download and install Office

  1. Go to and if you’re not already signed in, select Sign in.
  2. Sign in with the account you associated with this version of Office.
  3. After signing in, follow the steps that match the type of account you signed in with.
  4. This completes the download of Office to your device.

Where is my product key for Microsoft Office?

If Office came in a box, card, or disc, look for the product key on the card or on the packaging that came with Office. If the product key isn’t there, read the instructions on the package. You might be directed to go to to get your product key.