Open and use MS Excel with macro straight forward from network shares

asked 2023-01-03T09:10:26.183+00:00
Federico Coppola 1,106 Reputation points

Hello,
We have a DFS file server, so company clients access to network shares using this path \company.local\shares
These endpoint can access to DFS without trouble (they open, save file etc...).
I downloaded and applied ADMX for MS Office (download link) without issues.

I already setted up these configuration via Domain Group Policy:

Users > Policies > Administrative Templates > Microsoft Excel 2016 > Excel Options > Security > Trust Center > Trusted Location
Allow Trusted Locations on the network = enabled
Trusted location -> I setted up network path (Is date variable necessary? I left it empty)

Users > Policies > Administrative Templates > Microsoft Office 2016 > Security Settings > Trusted Location
Allow mix of policy and user locations = enable
Trusted location -> I setted up network path (Is date variable necessary? I left it empty)

At the end I added DFS namespace (\company.local\shares) inside "Site to Zone Assignment List"
I configured this settings via GPO Users > Windows Components > Internet Explorer > Internet Control Panel > Security Page

At the moment company clients can open MS Excels file, but they get warning to run Macro.
Is it possible open and use these MS Excel files straight forward from DFS network shares without any warning only from file server?
I would that company workmates can use these files without alert.

All PCs are using MS Office 365.

Can I do it?

Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
8,142 questions
Windows Group Policy
Windows Group Policy
A feature of Windows that enables policy-based administration using Active Directory.
1,869 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,333 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. answered 2023-01-04T05:46:37.263+00:00
    Emily Hua-MSFT 21,526 Reputation points Microsoft Employee

    Hi @Federico Coppola

    > Is it possible open and use these MS Excel files straight forward from DFS network shares without any warning only from file server?

    I am afraid we are unable to do it.

    Using Trusted Locations for Office files can prevent files include macros being blocked, however, there may still be warnings reminding users of the safety of such files from Internet.

    Thanks for your understandings.

    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.