question

MatthewGailer-3579 avatar image
0 Votes"
MatthewGailer-3579 asked BrandonLongley-6435 answered

Excel - Protected View - SharePoint Online

Hi,

I have a customer with a Modern Desktop based on Azure AD join, Intune and M365 Apps for Enterprise (Monthly Channel). Customer utilises SharePoint Online for files. Any Excel documents opened from SPO open in Protected View. All other Office documents (i.e. Word and PowerPoint) opened from the same SPO site do not open in Protected View. The Protected View message is "Be careful - files from the internet can contain viruses. Unless you need to edit it, it's safe to stay in Protected View". I've got the customer SharePoint Online site successfully configured and reporting as a "Local Intranet" site even, and still no dice. The SharePoint Online URL (https://customer.sharepoint.com) is in Trusted Locations in Office as well. If added as a mapped drive (manually via File Explorer or using "Cloud Drive Mapper") and I have that drive letter in Trusted Locations, I still get it.

Thoughts on what to try? I'm at my wits end. We don't want to get rid of the error by dropping the security level and not prompted for Protected View (for legitimate cases when a users has downloaded from the Internet).

Thanks,

Matt

windows-10-securityoffice-excel-itprooffice-itpro
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

emizhang-msft avatar image
0 Votes"
emizhang-msft answered

Hi @MatthewGailer-3579,
I suggest you open Excel and go to File- Options- Trust Center- Trust Center settings...- Protected View- uncheck all options:

159603-12.png

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.


If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.





12.png (47.1 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LimitlessTechnology-2700 avatar image
0 Votes"
LimitlessTechnology-2700 answered

Hi @MatthewGailer-3579

By default, Excel activates certain “protected view” settings. This is meant to prevent you from opening a potentially infected file downloaded from the Internet, sent to you in an Email, etc.

Only disable this setting if you are certain that any file you open is a trusted file. You can disable this setting by following the below steps.

-Click File > Options.
-Click Trust Center > Trust Center Settings > Protected View.
-Make selections that you want.

Protected View Trust Center settings explained
https://support.microsoft.com/en-us/topic/what-is-protected-view-d6f09ac7-e6b9-4495-8e43-2bbcdbcb6653

Hope this resolves your Query!!


--If the reply is helpful, please Upvote and Accept it as an answer--

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MatthewGailer-3579 avatar image
0 Votes"
MatthewGailer-3579 answered emizhang-msft commented

Thanks for the replies. I am aware of the concept of dropping the Protected View setting, but noting I did mention "We don't want to get rid of the error by dropping the security level and not prompted for Protected View (for legitimate cases when a users has downloaded from the Internet)". I'd like to explore the option of having my Trusted Locations work.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I think it's not possible to keep security level and remove protect view mode both.

0 Votes 0 ·
BrandonLongley-6435 avatar image
0 Votes"
BrandonLongley-6435 answered

Hello, you should add the customer's sharepoint to your list of Trusted Sites (Internet Options > Security Tab > Trusted Sites -- Sites). This solved my issue as a workaround for not deactivating protected view entirely.


181201-image.png



image.png (14.8 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.