Share via

Excel Open File - Security Warning for our own company SharePoint site, followed by network share

The Hoff_82 0 Reputation points
2024-08-20T15:23:46.53+00:00

I received a ticket from a single user who was receiving a security warning when opening an xlsx file on one of our SharePoint libraries. I added our SharePoint site to trusted locations in the domain group policy, which fixed the warning for files in that library. Now Excel started showing this warning for xlsx files in our network drive (W:) when it hadn't previously. I performed the same steps and added this network drive to trusted locations in the domain group policy and confirmed the user's PC did grab the new policy, but this time the warning persists.

Looking at other posts about this issue, and assuming this user is the only person receiving these warnings as no one else has raised this concern, I tried a few things on her local PC:

  1. Enabling 'Launching application and unsafe files' under the security tab in Internet Options.
  2. Adding the W drive to trusted locations in the Excel desktop app. The app would NOT allow this location to be saved.
  3. Manually adding the trusted location in the Excel desktop app via Registry. It does appear in the Excel trust center but is greyed out.

Excel_loc_1

Excel_loc_2

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,954 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,803 questions
Windows 10 Security
Windows 10 Security
Windows 10: A Microsoft operating system that runs on personal computers and tablets.Security: The precautions taken to guard against crime, attack, sabotage, espionage, or another threat.
2,926 questions
Windows Server Security
Windows Server Security
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Security: The precautions taken to guard against crime, attack, sabotage, espionage, or another threat.
1,850 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jing Zhou 7,105 Reputation points Microsoft Vendor
    2024-08-22T07:15:28.11+00:00

    Hello,

     

    Thank you for posting in Q&A forum.

    To fix this issue, please kindly try below steps:

    1.Go to Excel Trust Center Settings, and add the SPO site to trusted in the browser or via GPO for all users. You need to make sure “Check Microsoft Office documents that are from or link to suspicious Web sites” option is properly configured.

    2.Go to Internet Options -> Security -> Trusted sites and add the SPO site to check if it works.

     

    I hope the information above is helpful.

    If you have any questions or concerns, please feel free to let us know.

     

    Best regards，

    Jill Zhou

     

    If the Answer is helpful, please click "Accept Answer" and upvote it.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.