How can I set my personal OneDrive as a Trusted Location.

HYUNGJUNE KIM 1 Reputation point
2022-09-02T06:05:42.66+00:00

How can I set my personal OneDrive as a Trusted Location.

I want to set my personal OneDrive sync folder as the Office 365 Excel trusted folder.

As Internet-based Excel macro files were restricted this month, I checked the following documents. However, this document does not explain how to do personal OneDrive. The part described below seems to be for business use.

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

https://learn.microsoft.com/en-us/deployoffice/security/internet-macros-blocked

Set the Windows internet security zone assignment for OneDrive or SharePoint domains to Trusted Sites. Admins can use the "Site to Zone Assignment List" policy and configure the policy to place https://{your-domain-name}.sharepoint.com (for SharePoint) or https://{your-domain-name}-my.sharepoint.com (for OneDrive) into the Trusted Sites zone.

This policy is found under Windows Components\Internet Explorer\Internet Control Panel\Security Page in the Group Policy Management Console. It’s available under both Computer Configuration\Policies\Administrative Templates and User Configuration\Policies\Administrative Templates.

SharePoint permissions and OneDrive sharing aren't changed by adding these locations to Trusted Sites. Maintaining access control is important. Anyone with permissions to add files to SharePoint could add files with active content, such as macros. Users who download files from domains in the Trusted Sites zone will bypass the default to block macros.

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

I want to add the synced folder in my personal onedrive to the trusted folder in office 365 to use the excel file with macros.

OneDrive Management
OneDrive Management
OneDrive: A Microsoft file hosting and synchronization service.Management: The act or process of organizing, handling, directing or controlling something.
1,315 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,746 questions
{count} votes

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.