Hi @N Kerr,
To fix the issue where documents stored in SharePoint cannot be opened in Excel or Word due to trust center warnings, you can configure Group Policy Objects (GPO) to trust SharePoint sites. The following steps can help you accomplish this:
- Open the Group Policy Management Console.
- Create a new GPO or select an existing one.
- Navigate to User Configuration > Administrative Templates > Microsoft Office > Common > Trust Center.
- Click on "Trusted Locations".
- Click "Enable".
- Enter the path to the SharePoint site(s) in the "Path" field. For example, if the SharePoint site is "https://company.sharepoint.com/sites/team", then you would enter "https://company.sharepoint.com" as the path.
- Check the box next to "Subfolders of this location are also trusted".
- Click "OK" to save the changes.
- In the GPO Management Console, link the GPO to the desired organizational units.
After completing these steps, the settings should be applied to all users in the affected organizational units, and they should be able to access Excel and Word documents stored in SharePoint without receiving trust center warnings.
Note that this solution assumes that the issue is related to trust center warnings and not other potential issues such as problems with the SharePoint Web Client service or outdated versions of Office.
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
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.