Add SharePoint Online Document Library as a trusted location for Office Applications (Access)

Question

Add SharePoint Online Document Library as a trusted location for Office Applications (Access)

Wächter André 25

Hi all

We have blocked the execution of Macros via Group Policy for Office Applications. If needed, we add a location to a "trusted location" for the application. This works well for on-prem locations like file servers. How can I add a location in SharePoint Online as trusted location? The file itself will be opened in the local application, as macros do not work in the online versions of the apps. Actually I need this for an Access file/database.

Regards

André

1 answer

Your answer

Answer 1

Xyza Xue_MSFT 30,176 Microsoft External Staff

Hi @Wächter André ,

Thank you for posting in this community.

Configure Trusted Locations in Office:

Open the Office application (e.g., Access).
Go to File > Options.
Select Trust Center > Trust Center Settings.
Click on Trusted Locations.
Click Add new location.
Enter the path to your SharePoint Online Document Library.
Check the option Subfolders of this location are also trusted if needed.
Click OK to save the settings. Reference: https://learn.microsoft.com/en-us/microsoft-365-apps/security/trusted-locations#planning-steps-for-trusted-locations

If the answer is helpful, please click "Accept as 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.

Wächter André 25 Reputation points

2024-08-29T08:23:57.39+00:00

Hi @Xyza Xue_MSFT

Thank you for your answer. Unfortunately, this did not solve it. This is what I had done before my questions. I do this settings with a group policy, but this should not be the problem. The settings are correctly applied to Access. When I open the file from Sharepoint Online ("Open in App") it still blocks the macros. Maybe there is a different location needed as it open in the local application (as it has to be because of the macros).

Regards

André
Xyza Xue_MSFT 30,176 Reputation points Microsoft External Staff

2024-08-30T06:20:30.9033333+00:00

Hi, Try this method to see if it works for you:

On a Windows device goto Control Panel > Internet Options > Securrity Tab > Trusted Sites > Sites

Share via

Add SharePoint Online Document Library as a trusted location for Office Applications (Access)

1 answer

Your answer