How to open OLD Excel spreadsheets in Protected View

If in case you have an previous Excel spreadsheet, Excel opens it in regular view, which may be dangerous at instances when it’s downloaded from an unknown supply. As many individuals Unblock the downloaded file with out opening it, it’d get you into bother at instances. That’s the reason you may allow this setting to at all times open previous Excel spreadsheets in Protected View. It’s doable to try this utilizing the in-built setting, Native Group Coverage Editor, and Registry Editor.

How to make Excel open OLD spreadsheets in Protected View

To at all times open previous Excel spreadsheets in Protected View, comply with these steps:

1. Open Microsoft Excel in your laptop.
2. Click on on the Choices menu.
3. Change to the Belief Middle tab.
4. Click on the Belief Middle Settings button.
5. Go to the File Block Settings tab.
6. Tick all of the checkboxes associated to previous Excel variations.
7. Click on the OK button.

To know extra about these steps, proceed studying.

First, you want to open Microsoft Excel and click on on the Choices menu seen in the bottom-left nook. Then, go to the Belief Middle tab, click on on the Belief Middle Settings button, and change to the File Block Settings tab.

After that, be sure that the Open chosen file varieties in Protected View possibility is chosen. In that case, tick all of the Open checkboxes which can be associated to the previous model of Excel.

For instance, you want to tick the Excel 2007 and later Workbooks and Templates, Excel 97-2003 Workbooks and Templates, and so on.

Lastly, click on the OK button to save the change.

Open previous Excel spreadsheets in Protected View utilizing Group Coverage

To open previous Excel spreadsheets in Protected View utilizing Group Coverage, comply with these steps:

1. Seek for gpedit and click on the search consequence.
2. Navigate to File Block Settings in Consumer Configuration.
3. Double-click on the Excel 2007 and later workbooks and templates setting.
4. Select the Enabled possibility.
5. Choose the Open in Protected View possibility.
6. Click on the OK button.
7. Repeat these steps for different older variations of Excel.

Let’s delve into these steps in element.

To get began, you want to open the Native Group Coverage Editor. To do this, seek for gpedit in the Taskbar search field and click on on the person search consequence.

Then, navigate to the next path:

Consumer Configuration > Administrative Templates > Microsoft Excel 2016 > Excel Choices > Safety > Belief Middle > File Block Settings

Double-click on the Excel 2007 and later workbooks and templates setting and select the Enabled possibility.

Then, choose the Open in Protected View possibility and click on the OK button.

Subsequent, you want to repeat the identical steps for all of the older variations of Excel which can be talked about in the identical path.

All the time open previous Excel spreadsheets in Protected View utilizing Registry

To at all times open previous Excel spreadsheets in Protected View utilizing Registry, comply with these steps:

1. Press Win+R > sort regedit > click on the OK button.
2. Click on the Sure button.
3. Navigate to Microsoftoffice16.0excel in HKCU.
4. Proper-click on excel > New > Key and title it as safety.
5. Proper-click on safety > New > Key and title it as fileblock.
6. Proper-click on fileblock > New > DWORD (32-bit) Worth.
7. Set the title as xlsxandxltxfiles.
8. Double-click on it to set the Worth knowledge as 4.
9. Click on the OK button and restart your PC.

Let’s try these steps in element.

You want to begin the method by opening the Registry Editor in your laptop. For that, press Win+R > sort regedit > click on the OK button and click on on the Sure possibility.

After that, navigate to this path:

HKEY_CURRENT_USERSoftwarePoliciesMicrosoftoffice16.0excel

Proper-click on excel > New > Key and title it as safety.

Then, repeat the identical steps and create a sub-key beneath the safety key, and set the title as fileblock. Following that, right-click on fileblock > New > DWORD (32-bit) Worth and title it as xlsxandxltxfiles.

Subsequent, double-click on it to set the Worth knowledge as 4 and click on the OK button.

As soon as finished, you may set the REG_DWORD worth for different older variations of Excel as nicely. For that, you want to use these names: xl9597workbooksandtemplates, xl95workbooks, xl97workbooksandtemplates, and so on.

Lastly, restart your PC to get the change. Alternatively, you may signal out and re-sign in to your account as nicely.

Learn: How to ALWAYS open OLD PowerPoint shows in Protected View

How do I open an Excel file that gained’t open in Protected View?

To open an Excel file that gained’t open in Protected View, you want to unlock it first. Usually, it occurs once you attempt to open a downloaded file in Excel. In such conditions, you may right-click on the file, choose Properties, and tick the Unlock button.

Learn: How to open OLD Phrase paperwork in Protected View

How do you open an Excel sheet that’s protected?

To open an Excel sheet that’s protected, you have to unlock it first. For that, you may right-click on the file and tick the Unlock checkbox. Second, you may double-click on the file and click on on the Allow Modifying button. Then, you may open and edit the protected view with none restriction.

Additionally learn: How to at all times open PDF information in Protected View in Phrase.