8: Remove Protected-View Of Excel
Excel file that gets opened from a potentially unsafe location like the internet, email attachments, downloaded from any third party source, etc. are opened in protected view.
This feature of Excel Protected-View restricts the user to make any modification in their opened Excel spreadsheet.
So, you can turn off the Protected-View security warning messages in Excel to resolve Excel 2016 open and close immediately like problems.
here are the steps to followed to remove Excel file from Protected-View :
- Open MS Excel
- Go to the File ->Options
- Select the Trust Centre ->Trust Centre Settings
- Click on the Protected View
- Uncheck all the options
Also, change the below-given settings
- Under the Trust Centre settings,
- Click on the ‘File Block Settings’
- Uncheck all the options and click the OK button.